Wednesday, April 1, 2009

T-SQL Article Published in Print Book


I'm excited to have my T-SQL article published in the Best of SQLServerCentral, Volume 6 print book. The article entitled "Owning the Spelling Suggestion Feature" demostrates how to build the data set for an Ecommerce product key word search spell correction feature. To view the full article, go here.


I first show how to break apart product descriptions into individual records using set-based techniques. I then show how to create the four main misspelling patterns that can be derived programatically: 1. Double letter. 2. Missing letter. 3. Transposed. 4. QUERTY misspelling. I create a T-SQL statement that generates all these misspellings from the proper spelling. From there, it is possible to create a stored procedure that takes a key word search and checks for a match on the misspelled column to retrieve the proper spelling.


An Ecommerce shopping cart can display a help tip such as "Did you mean ?" I have build just such a feature at YearOne.com. For a demonstration, go to this YearOne.com Example