• Regarding number of round trips... In my implementation of spell suggestion, I use a single stored procedure call which uses a single T-SQL statement using a set-based approach even though the search entry is often multiple words. The search entry goes in, empty or filled spelling suggestion message goes out.

    Although the performance seems great, I'd like to take the chance later to go into the specifics of the stored procedure including the performance angle and see if Andy and some of the other performance gurus around here will share their optimization tips.

    Thank you everybody for taking the time to read. Let me know if you find other helper table techniques!

    Bill

    Bill Nicolich: www.SQLFave.com.
    Daily tweet of what's new and interesting: AppendNow