The FREETEXT predicate determines whether or not a value reflects the meaning, rather than the exact words, specified in the predicate.
The FREETEXT predicate syntax is as follows:
This is a simple form of natural language query, where the index engine internally breaks the freetext string into a number of search terms, generates the stemmed form of the words, assigns heuristic weighting to each term, then finds the matches.
Here is an example of a FREETEXT predicate used in a WHERE clause.
WHERE FREETEXT( Contents, ' Who have been the most valuable ice hockey players from 1975 through 1982? ' )