search stored procedures by name

1select * 
2from 
3   sys.procedures 
4where 
5   name like '%name_of_proc%'
6

1SELECT DISTINCT
2       o.name AS Object_Name,
3       o.type_desc
4  FROM sys.sql_modules m
5       INNER JOIN
6       sys.objects o
7         ON m.object_id = o.object_id
8 WHERE m.definition Like '%[ABD]%';