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.
This section describes the system functions related to full-text search and semantic search.
Full-Text Search Functions
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.
Semantic Search Functions
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.