O Olly Fingers like lightning Joined Jan 31, 2007 Messages 758 Likes received 0 Thanks received 0 Jun 11, 2010 13:38 #1 Hi, I've got list of people's names that I need to match against another list of peeps Anyone know of any good routines for this kind of fuzzy matching? Maybe you know of a table of common mistakes. Mac = Mc etc Mike = Michael ? thanks very much
Hi, I've got list of people's names that I need to match against another list of peeps Anyone know of any good routines for this kind of fuzzy matching? Maybe you know of a table of common mistakes. Mac = Mc etc Mike = Michael ? thanks very much
doodab Contractor 'til I die Joined Jan 28, 2010 Messages 16,178 Likes received 516 Thanks received 117 Location A bit too close to Wandsworth Jun 11, 2010 13:39 #2 Olly said: Hi, I've got list of people's names that I need to match against another list of peeps Anyone know of any good routines for this kind of fuzzy matching? Maybe you know of a table of common mistakes. Mac = Mc etc Mike = Michael ? thanks very much Click to expand... I've used oracle's implementation of this before. Soundex - Wikipedia, the free encyclopedia
Olly said: Hi, I've got list of people's names that I need to match against another list of peeps Anyone know of any good routines for this kind of fuzzy matching? Maybe you know of a table of common mistakes. Mac = Mc etc Mike = Michael ? thanks very much Click to expand... I've used oracle's implementation of this before. Soundex - Wikipedia, the free encyclopedia
R rsingh Fingers like lightning Joined Sep 24, 2007 Messages 521 Likes received 9 Thanks received 4 Jun 11, 2010 13:46 #3 There's also a version in MSSQL for this. See the following page
O Olly Fingers like lightning Joined Jan 31, 2007 Messages 758 Likes received 0 Thanks received 0 Jun 11, 2010 13:51 #4 oops forgot to add....this is running under MS Access
O Olly Fingers like lightning Joined Jan 31, 2007 Messages 758 Likes received 0 Thanks received 0 Jun 11, 2010 13:59 #5 This looks like the puppy Fuzzy Matching Demo in Access - CodeGuru a DB of names and uses a few fuzzy algorithms...looks like I've got my work cut out digging through it all
This looks like the puppy Fuzzy Matching Demo in Access - CodeGuru a DB of names and uses a few fuzzy algorithms...looks like I've got my work cut out digging through it all
Platypus Ducklike Joined Dec 10, 2007 Messages 9,144 Likes received 627 Thanks received 182 Location In the pub Jun 11, 2010 14:28 #6 I've looked into this very heavily in the past. Arguably, SMITH and MSITH are the same name, due to a typo. Or SMITH and WMITH In my case, I used several algorithms to judge similarity between names and addresses, and weighted them to give a final score. Here's a link you may find useful: Approximate string matching - Wikipedia, the free encyclopedia Also Google for N-Gram, Levenstein and Hamming.
I've looked into this very heavily in the past. Arguably, SMITH and MSITH are the same name, due to a typo. Or SMITH and WMITH In my case, I used several algorithms to judge similarity between names and addresses, and weighted them to give a final score. Here's a link you may find useful: Approximate string matching - Wikipedia, the free encyclopedia Also Google for N-Gram, Levenstein and Hamming.
mudskipper TPAFKAk2p2 Joined Sep 12, 2009 Messages 26,487 Likes received 6,761 Thanks received 1,926 Location Null island Jun 11, 2010 16:50 #7 Olly said: oops forgot to add....this is running under MS Access Click to expand... Maybe this will be useful...
Olly said: oops forgot to add....this is running under MS Access Click to expand... Maybe this will be useful...
O Olly Fingers like lightning Joined Jan 31, 2007 Messages 758 Likes received 0 Thanks received 0 Jun 14, 2010 13:24 #8 right then...I'm getting there with this I've built a small table from existing matched data of names and abbreviations eg. William = Bill I'd really like a full multicultural data set...any pointers please?
right then...I'm getting there with this I've built a small table from existing matched data of names and abbreviations eg. William = Bill I'd really like a full multicultural data set...any pointers please?