Why not use sp_ExecuteSQL and build up the query that is needed in T-SQL code. This will cache the execution plan for the query statement.

The other thing I would suggest is that if you are going to using multiple LIKE '%[some string]% then you consider using full text indexes.