MS-Sql Server Full-Text Search
There are four principal T-SQL functions which allow one to interact with your Full-Text indices: CONTAINS, FREETEXT, CONTAINSTABLE and FREETEXTTABLE. The first two return a boolean value, meaning you could use them directly in a WHERE clause. The latter two return a two-column table ”KEY and RANK, allowing one to manage ranked searches.
CONTAINS and FREETEXT are quite similar functions. Both return a boolean value, and both take 2 parameters: a Free-Text indexed column name and the Free-Text search term. But they behave quite differently.
I have used FREETEXT to successfully search for products that are indexed in a table.
See http://www.sitepoint.com/sql-server-full-text-search-protips-part-2-contains-vs-freetext/ for more information.