Below small query will list all the procedures that contains specific text.
SELECT OBJECT_NAME(object_id), definition FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1 AND definition LIKE '%SearchText%'