1

IS there a way to find common misspellings in sql server?For example, if I had a legitimate search… like “Forclosure” instead of “Foreclosure”, is there a way to find the connection within a table without doing LIKE or CASE WHEN?

user2014904
  • 81
  • 1
  • 8
  • You might be able to use some [fuzzy matching techniques](http://stackoverflow.com/questions/921978/fuzzy-matching-using-t-sql) to find something similar to the search string. But this question has more to do with text searching than with SQL, so you might want to look at something like Lucene, which supports this [feature](http://stackoverflow.com/questions/348093/did-you-mean-feature-in-lucene-net). – Pondlife Mar 14 '13 at 21:08

1 Answers1

1

I’m not 100% sure it will work but you can try experimenting with SOUNDEX function and see if it can give you any results.

SOUNDEX converts an alphanumeric string to a four-character code that is based on how the string sounds when spoken.

For example:

SELECT SOUNDEX ('Smith'), SOUNDEX ('Smythe');

Gives same results for both

Kenneth Hampton
  • 685
  • 6
  • 7