-search-sql-fulltextpredicates.md

description	ms.assetid	title	ms.topic	ms.date
The Microsoft Windows Search query language supports two full-text search predicates.	c753dddb-57ed-40e6-8e49-ba5b6425fdd5	Full-Text Predicates	article	05/31/2018

Full-Text Predicates

The Microsoft Windows Search query language supports two full-text search predicates. The CONTAINS predicate performs comparisons on columns that contain text. The CONTAINS clause can perform matching on single words or phrases, based on the proximity of the search terms. In comparison, the FREETEXT predicate is tuned to match the meaning of the search phrases against text columns.

This section contains the following topics:

• CONTAINS Predicate
• FREETEXT Predicate

Related topics

Reference

FROM Clause

SCOPE and DIRECTORY Predicates

Conceptual

Non-Full-Text Predicates