jwolthuis - 5:53 pm on Aug 3, 2011 (gmt 0)
We use SQL Server Full-Text Search, which is free with SQL Server Express.
The issue isn't just misspellings, it's also plurals and word-ordering. You may sell a:
"Large Blue Widget",
...but if a customer searches for:
"Large Blue Widgets", or
"Large Widgets", or
"Blue Large Widget"
... your search *must* return your "Large Blue Widget" in the results. A simple SQL LIKE search will fail with these three examples.
Give SQL Server Full-Text Search a try.