SQL Server's Full-Text Search offers powerful and efficient ways to search your data.

However, the query syntax can be rather crypticIt's bad enough for SQL programmers, but what if you want to allow your users to enter queries? Unless all your users are database experts, they won't know or understand syntax like FORMSOF(INFLECTIONAL, dogs) AND FORMSOF(THESAURUS, cats).

Some time ago, I ran into the excellent article A Google-like Full Text Search by Michael ColesT...
Shout it
Only $4.95/month – Windows 2008/ASP.NET 4 Hosting!
.