Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
This section describes the system functions related to full-text search and semantic search.
Full-text search functions
| Article | Description |
|---|---|
| CONTAINSTABLE | 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 | 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. |
Semantic search functions
| Article | Description |
|---|---|
| semantickeyphrasetable | Returns a table with zero, one, or more rows for those key phrases associated with columns in the specified table. |
| semanticsimilaritydetailstable | 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 | Returns a table of zero, one, or more rows for those columns whose content is semantically similar to a specified document. |