| title | Full-Text Search and Semantic Search Functions (Transact-SQL) | |
|---|---|---|
| description | Full-text search and semantic search functions (Transact-SQL) | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| ms.reviewer | randolphwest | |
| ms.date | 10/20/2025 | |
| ms.service | sql | |
| ms.subservice | system-objects | |
| ms.topic | reference | |
| helpviewer_keywords |
|
|
| dev_langs |
|
[!INCLUDE SQL Server]
This section describes the system functions related to full-text search and semantic search.
| 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. |
| 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. |