Search (SQL Server)
SQL Server provides search features for text and documents that go beyond the functionality of the Transact-SQL LIKE keyword.
Full-Text Search (SQL Server)
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.