The FREETEXT predicate is used to determine whether or not values in full-text registered columns reflect the meaning, rather than the exact words, specified in the predicate.
The FREETEXT predicate syntax is as follows:
This is a basic 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, and then finds the matches.
Here is an example of a FREETEXT predicate used in a WHERE clause.
WHERE FREETEXT (articles, ' Who have been the most
valuable players for the Montreal Canadien? ' )