Join names with spelling mistakes

sguindi

I am trying to determine whether 2 users are the same person or not.. usually there is a letter missing or a couple of letters have different order.. i tried the fuzzy match, make group, find replace with no luck 😞

User1                    User2

Armstrong            amstrong

Macau                  Macua

DonaldSterling     DSterling

TIA !

fmvizcaino

Hi @sguindi ,

Attached is an example showing how to get that done with fuzzy match.

I'm leaving a threshold of 50% but you can tune for your problem.

Let me know if that works for you.

Best,

Fernando Vizcaino

2019-12-20 Join names with spelling mistakes.yxmd