Fuzzy Duplicate

abrahma

Forums

Hi Brian,
Hope you are well.
Quick question about fuzzy duplicate:
I am try to group similar names coz names come in as free text and tend to error prone.
Current output from fuzzy duplicate match:
Name                                   Group Name (from Fuzzy)
John Smith                            John Smith
Smith, John                           Smith John
 
Why does it not match when first name and last name are reverse but exactly the same? do you have any suggestion how I can match those as well?
Thank you,
Ashwini
 

Brian Element Fri, 10/18/2019 - 17:43

I think it is because it uses the Levenshtein distance algorythm so the it measures the distance between letters, I assume in your case since they are reversed instead of just having typos that the distance is to far apart.  In your example they are using a comma when they are reversed, maybe create a virtual field and if it contains a comma then you reverse the name and then do the fuzzy match, that would make up this scenario.