- MATCHED
- UNIQUE
- REVIEW
- CLEANED
Short answer
How do I deduplicate contact lists with my AI?
Your AI uses mathematical similarity scores to identify records that look different but represent the same person. It flags these matches so you can merge them without manual searching. You'll get a clean list of unique entries after the comparison is done.
The results.
Where your data ends up.
The AI processes your raw data and sorts the results into these categories.
MATCHED
Identified duplicates
The AI finds records with high similarity scores. You get a list of pairs that are likely the same person.
UNIQUE
Cleaned records
Records with no close matches are kept as they are. These are your verified, single entries.
REVIEW
Needs human eyes
Low-confidence matches fall into this bucket. You decide if these borderline cases should be merged or kept separate.
CLEANED
Ready for export
The final, deduplicated dataset is ready to be moved back into your CRM or spreadsheet.
The workflow
What your AI does when the list arrives.
The AI doesn't just look for exact matches; it calculates how close strings are to one another.
Analyze text similarity
The AI looks at names, emails, and addresses to see how much they overlap mathematically.
calculate_fuzzy_distanceScore the matches
Every pair of records gets a score. Higher scores mean the records are almost certainly the same person.
calculate_fuzzy_distanceFlag suspicious entries
The AI separates high-confidence matches from those that are too vague to be certain.
calculate_fuzzy_distancePrepare the merge
The AI organizes the identified duplicates so you can review the changes before they become permanent.
calculate_fuzzy_distance
Try it
Copy these to start.
Use these prompts to kick off the deduplication process.
Starting points
Replace the bracketed text with your specific file names or sheet names.
Native V8 Connector
You're all set. Choose your MCP client and follow the setup instructions.
https://edge.vinkius.com/vk_preview_xvVQOLDybWIA1r0Xqh3QvkWg4DBUiJY5auBfso8h/mcpClaude Desktop
Follow the steps below to connect in seconds.
- 1In Claude Desktop, open Settings → Connectors.
- 2Click “Add custom connector” and paste the connector link above as the remote MCP server URL.
- 3Click Add and start a new chat — Native V8 capabilities are ready to use.
{
"mcpServers": {
"fuzzy-string-distance-engine-mcp": {
"url": "https://edge.vinkius.com/vk_preview_xvVQOLDybWIA1r0Xqh3QvkWg4DBUiJY5auBfso8h/mcp"
}
}
}Compare the names in my 'Leads' Google Sheet and find duplicates using fuzzy matching.
Check this CSV file for duplicate contact entries that have slightly different spellings.
Look through my CRM export and flag any records that have a high similarity score.
Identify potential duplicate customers in the 'Customer_List.csv' file.
Claude
ChatGPT
Cursor
VS Code
Windsurf
Claude Code
JetBrains
Cline
Start here
Connect Fuzzy String Distance Engine once, then ask.
Just click to connect. Your credentials stay encrypted, and you can start chatting with your data immediately.
Connect Fuzzy String Distance Engine to your AIFAQ
How this task behaves
- 01
Will the AI automatically delete my duplicate contacts?
No. The AI only identifies and flags potential duplicates. You must manually confirm or trigger the deletion in your own software.
- 02
Can it find duplicates if the names are spelled completely differently?
It can find matches if the mathematical similarity is high enough, but if there is no overlapping character data, it won't find them.
- 03
Does it work on email addresses too?
Yes, it can calculate the distance between any text strings, including email addresses.
- 04
Will it change my original spreadsheet?
No. The AI reads your data to perform calculations, but it does not write back to or modify your source files unless you specifically use a tool to do so.
- 05
How accurate is the fuzzy matching?
Accuracy depends on the similarity score threshold you set. You can ask the AI to be strict or more lenient with its matches.
More questions about Fuzzy String Distance Engine? The Connector page answers them. See everything the Fuzzy String Distance Engine Connector can do
Connect Native V8 to Claude, Cursor, ChatGPT & more
