Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Full-Text Search and Semantic Search Functions (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

This section describes the system functions related to full-text search and semantic search.

CONTAINSTABLE (Transact-SQL)

Returns a table of zero, one, or more rows for those columns containing precise or fuzzy (less precise) matches for single words and phrases, the proximity of words within a certain distance of one another, or weighted matches.

FREETEXTTABLE (Transact-SQL)

Returns a table of zero, one, or more rows for those columns containing values that match the meaning, and not just the exact wording, of the text in the specified freetext_string.

semantickeyphrasetable (Transact-SQL)

Returns a table with zero, one, or more rows for those key phrases associated with columns in the specified table.

semanticsimilaritydetailstable (Transact-SQL)

Returns a table of zero, one, or more rows of key phrases common across two documents (a source document and a matched document) whose content is semantically similar.

semanticsimilaritytable (Transact-SQL)

Returns a table of zero, one, or more rows for those columns whose content is semantically similar to a specified document.

Community Additions

ADD
Show:
© 2015 Microsoft