Search (SQL Server)
Applies To: SQL Server 2016
SQL Server provides search features for text and documents that go beyond the functionality of the Transact-SQLLIKE keyword.
Identifies text or documents that contain specific words or phrases, and that meet additional search conditions such as proximity of search terms.
Semantic Search (SQL Server)
Identifies the key phrases in text or documents, discovers similar or related documents, and provides information to explain how documents are similar or related.