you can use the full text indexing services of sql server. But even then you will need to manage the thesaurus files for sql server. check this link http://msdn.microsoft.com/en-us/library/ms142571.aspx
I had built a similar search feature using sql server full text indexing.
NOTE: pls mark the answer as solution if it fulfills your critirea