Using the CONTAINS and FREETE XT Predicates

2 Articles

The FREETEXT Predicate

Last Updated On : Sunday, May 24, 2015The FREETEXT predicate is less specific and thus returns more rows than the CONTAINS predicate. It searches for the values that match the meaning of a phrase and not just exact words. When you use the FREETEXT predicate, the engine performs word breaking of the search phrase, generates […]

The CONTAINS Predicate

Last Updated On : Tuesday, May 7, 2019With the CONTAINS predicate, you can search for the following: Words and phrases in text Exact or fuzzy matches Inflectional forms of a word Text in which a search word is close to another search word Synonyms of a searched word A prefix of a word or a […]