The actual post is Ok for the tables which are of One word for others below is the modified query.

DECLARE @searchSQL AS VARCHAR(MAX)

DECLARE @SearchItem AS VARCHAR(MAX) ; SET @SearchItem =...