/*Replace Text to search and exclude with your requirements*/
 
DECLARE @toSearch VARCHAR(255) = 'TEXT_TO_SEARCH', @toExclude VARCHAR(255) = 'TEXT_TO_EXCLUDE';
SELECT DISTINCT SYSOBJECTS.name AS [Object Name] ,
CASE WHEN SYSOBJECTS.xtype = 'P' THEN 'sql Stored Proc'
WHEN SYSOBJECTS.xtype = 'TF' THEN 'sql Function'
WHEN SYSOBJECTS.xtype = 'TR' THEN 'sql Trigger'
WHEN SYSOBJECTS.xtype = 'V' THEN 'sql View'
END AS [Object TYPE]
FROM SYSOBJECTS,SYSCOMMENTS
WHERE SYSOBJECTS.id = SYSCOMMENTS.id
AND SYSOBJECTS.type IN ('P','TF','TR','V')
AND SYSOBJECTS.category = 0
AND CHARINDEX(@toSearch,SYSCOMMENTS.text)>0
AND ((CHARINDEX(@toExclude,SYSCOMMENTS.text)=0 
OR CHARINDEX(@toExclude,SYSCOMMENTS.text)0)) 

The above query can be modified to search for more system object types, list of sys.sysobjects

A personal technical diary… To the point… Precise