Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjeev1
Contributor
Contributor

Algorithm for matching duplicate names

I need to identify name duplicates containing friendly and official names in a dataset. For e.g -

 

1) William Stark (official name)

     Bill Stark (Friendly Name)

 

2) Bradley Thomas (Official Name)

    Brad Thomas (Friendly Name)

 

3) Robert Gordon (Official Name)

    Bob Gordon (Friendly Name)

 

I was looking at Jaro, Jaro-Winkler and Soundex algorithms, but I'm wondering whether there are better methods. Appreciate any guidance/ best practises you can provide.

Labels (2)
0 Replies