by By Thomas Keller, 2014/01/10 (first published: 2012/09/18)
http://www.sqlservercentral.com/articles/Fuzzy+Match/92822/
Fuzzy-String Search: Find misspelled information with T-SQL
By Thomas Keller, 2014/01/10 (first published: 2012/09/18)
How many times has a user told you that they entered a contact into your CRM system, and now they cannot locate it by name? Then, after you help them locate it by some other means, it turns out that either the original entry or the search term was misspelled? Would you like your search to be able to suggest alternates when a key word is misspelled?
When "fuzzy" string matching is most helpful
Whether it's misheard, mistyped, poorly scanned, or copied and pasted from a bad source, misspelled information is a common irritant to the user. If a user can't find the record they're looking for quickly, they will probably enter it again. If it's your job to merge the duplicates, then it's to your advantage to provide your users with a "fuzzy" search option. It may take a few seconds longer, so don't make it your default search. Just give your users the option, and they will learn to try it when their first search doesn't find what they're looking for. If they start entering a new record anyway, you can also launch a background process right after the user fills in the key field(s), which can alert them to potential duplicates before they are ready to hit the save button.
No comments:
Post a Comment