create fuzzy logic for name search sql

Question

I'm trying to create a fuzzy logic to match similar names like rob and robert. The SQL Soundex function for these 2 words is providing a larger difference, which is not useful. Is there another way to find name matches.

http://stackoverflow.com/questions/921978/fuzzy-matching-using-t-sql — Siyual, Sep 16 '14 at 18:07

score 1 · Answer 1 · edited May 23 '17 at 10:33

1

A quick and simple way would be to use the search string "rob*" instead of "rob" or "robert". This is a crude and simple way and would not work with nicknames that spelled differently than the begining of the fullname. For example, "Bob" wouldn't be caught.

To cover all these nickname and similar names, See This Answer

edited May 23 '17 at 10:33

Community

1
1

answered Sep 17 '14 at 13:23

mdw7326

434
7
28

create fuzzy logic for name search sql

1 Answers1