SQL Server Performance Forum – Threads Archive
a simple spell checking algorithm in T-SQLHi, I need some help with a simple spell check algorithm in T-sql. My problem is as follows: I have two tables, misspelledTable, correctlyspelledTable. They both contain some phrases. I want to create a mapping from misspelledTable to correctlyspelledTable so that I have a new version of misspelled table in which all the rows of misspelledTable are correctly spelled w.r.t. correctlyspelledTable. This mapping should match each misspelledTable row to the most appropriate row in correctlyspelledTable. Please advice me. Thank you,
You can compare the words by using some SQL Server functions
See Soundex and Difference in Books On Line
Madhivanan Failing to plan is Planning to fail
Why do you want to store those data in the table.
instaed you can use word spell checker utility