For SQL Server 2008 R2 or earlier, I'd recommend running a SQL Server Profiler session against the server.
On the General tab, in the template dropdown, select "Blank", then on the Events Selection tab, choose "SQL_StmtStarting" from the list of events. Click the "Column Filters" button, and fill it out similar to this:
When you run this profiler session, the results will only show you rows where the TextData column contains the text you entered.
On SQL Server 2012 and above, I'd recommend using Extended Events to do this, however that is out of the scope of this question.