Dedupe App - It won't recognize a duplicate between Daniel and Dan and other similar names. What am I doing wrong?

[Gaelen_Kash]

Dedupe seems like a good product, but I must be doing something wrong. I have a TON of duplicates in my table. First name is Dan/Daniel, Greg/Gregory, Joe/Joeseph, Rob/Robert, etc… Last names are identical and so is all of the other information. Dedupe isn’t recognizing ANY of them. Am I doing something wrong in the settings? Or what am I supposed to do to help recognize these duplicates

[ScottWorld]

You’ve already asked that question here:

Dedupe App is fantastic! Apps

@ScottWorld @kuovonne @Taylor_Savage @Jason @Raghav_Sethi Help me understand how to use the features of Dedupe. It does seem pretty straightforward, but it is NOT recognizing that Daniel Nelson and Dan Nelson (for example) are the same person and should be a duplicate. It’s not even offering it as a suggestion. As I’ve been manually going through my database I keep running into use cases that are going unrecognized as duplicates. I can’t figure out what I am doing wrong. Help!

Those are not duplicates, which is why Airtable isn’t recognizing them as duplicates.

[Gaelen_Kash]

One record that is Daniel Nelson and another record that is Dan Nelson are not considered duplicates? Or Rob Brown and Robbie Brown? I’m confused what constitutes a duplicate.

[Kamille_Parks]

“Rob Brown” is a duplicate of “Rob Brown”. By definition “Robbie” is not the same as “Rob”. Now, the Dedupe App does have an option for ‘fuzzy matching’ which may pick up the same text with extra spaces, simple misspellings or typos (i.e. it may pick up “Rob Brown” = “Rob Brwn”). But the app isn’t going to recognize nicknames no matter how common they are.

[Gaelen_Kash]

OK, I get it. It picks up mis spellings but two identical records of Company, email, title, cell phone number, etc except one with Rob Brown and the other with Robert Brown or Dan and Daniel Brown it is skipping. Frustrating, but I understand. Looking for something that might help with that! I tried selecting all of those fields as a test, but it still didn’t register. I tried Exact, Similar and Fuzzy and none of them worked. Arghhhhh

[ScottWorld]

You don’t have to force it to match on people’s names. If you have identical email, company, title, and cell phone, then just have it match on those fields! Or even just a few of those fields! Spend some time familiarizing yourself with the documentation here:

Airtable - Support

Dedupe app

The dedupe app is part of Airtable Apps, a Pro plan feature. Apps let you extend the functionality of your bases: you can use apps to bring new information into Airtable, visualize and summarize yo...