Find all occurrances of variable declaration

SELECT object_name(object_id)
FROM sys.sql_modules
WHERE definition LIKE '%@EmailId varchar(50)%'