Full Text Index Search

CONTAINS

SELECT Name, ListPrice  
FROM Production.Product  
WHERE CONTAINS(Name, 'Mountain')  

FREETEXT

SELECT Title  
FROM Production.Document  
WHERE FREETEXT (Document, 'vital safety components') 

Sources:

https://docs.microsoft.com/en-us/sql/relational-databases/search/full-text-search?view=sql-server-ver15