DECLARE @SearchTerm VARCHAR(MAX) = 'INSERT' -- Just an example

SELECT ROUTINE_NAME [Procedure]
, SPECIFIC_CATALOG [Database]
FROM INFORMATION_SCHEMA.ROUTINES
WHERE SUBSTRING(ROUTINE_DEFINITION, 54, 20) LIKE '%'+@SearchTerm+'%'
AND ROUTINE_TYPE = 'PROCEDURE'
ORDER BY [Procedure]

Procedure     Database
pGetAnimals   Zoo
pGetGreens    Food
pGetBeans     Food
pGetChocolate Food