Four SQL clauses allow you to conduct full-text searches on your full-text index tables:
CONTAINS—Specifies a strict exact match, with options to make the search flexible.
CONTAINSTABLE—Returns a ranked rowset from SQL Server FTS implementing the
Contains algorithm, which must be joined against the base table.
FREETEXT—Specifies a stemmed search that returns results to all generations of the search phrase.