CODEWITHSUNDEEP
sqlsql-server
user2014904
user2014904

Reputation: 77

find common misspelled searches in SQL Server

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?

Upvotes: 1

Views: 576

Answers (1)

Kenneth Hampton
Kenneth Hampton

Reputation: 705

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

Upvotes: 1

Related Questions