I very often have to locate the text of views or stored procedures that include something like "WHERE Comonent_Name LIKE 'CORE[_]" Using "Whole words" gets a ton of stuff I do not need.

Consider a stored procedure that has:

Exec Systemx.dbo.QueueEmail @Subject N'Failed to import from source'

Searching "Failed to import from source" with Match whole words only will fail to find the sproc in question, because it considers "N'" to be part of the whole word.

Example: find whole string - ID in (1,4)