Updated: July 29, 2016Applies To: SQL Server 2016Full-Text Search in SQL Server and Azure SQL Database lets users and applications run full-text queries against character-based data in SQL Server tables.
Each full-text index indexes one or more columns from the table, and each column can use a specific language.
Full-text queries perform linguistic searches against text data in full-text indexes by operating on words and phrases based on rules of a particular language such as English or Japanese.
Full-text queries can include simple words and phrases or multiple forms of a word or phrase.
A full-text query returns any documents that contain at least one match (also known as a Full-text queries are not case-sensitive.
For example, searching for "Aluminum" or "aluminum" returns the same results.
Full-text queries use a small set of Transact-SQL predicates (CONTAINS and FREETEXT) and functions (CONTAINSTABLE and FREETEXTTABLE).However, the search goals of a given business scenario influence the structure of the full-text queries.For example: In contrast to full-text search, the LIKETransact-SQL predicate works on character patterns only.Also, you cannot use the LIKE predicate to query formatted binary data.Furthermore, a LIKE query against a large amount of unstructured text data is much slower than an equivalent full-text query against the same data.A LIKE query against millions of rows of text data can take minutes to return; whereas a full-text query can take only seconds or less against the same data, depending on the number of rows that are returned.