SQL Server Performance

a simple spell checking algorithm in T-SQL

Discussion in 'T-SQL Performance Tuning for Developers' started by cobrak1980, Jun 10, 2005.

  1. cobrak1980 New Member

    Hi,

    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,
    Nagu
  2. Madhivanan Moderator

    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
  3. dineshasanka Moderator

Share This Page