Replace "Search_String", below, with the string you want to find.

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Search_String%'
AND ROUTINE_TYPE='PROCEDURE'