I've tested this query against sample DB and against my current search query:

select distinct object_name(sc.id) [name]

from syscomments sc

Where PatIndex('%<text, varchar(200),>%' , text ) > 0

However posted query is a little bit faster, it does not work correctly. In my test, my procedure returned 2 more SP, and thay had a string I looked for.