DECLARE @query_text NVARCHAR(1024)
SET @query_text = '%SELECT this_.EmailID, this_.EmailAddress%FROM Email WHERE EmailAddress%'

SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SET LOCK_TIMEOUT 10000

SET @query_text = REPLACE(REPLACE(@query_text, '[', '\['), '\\[', '\[')

SELECT
    cp.cacheobjtype,
    cp.objtype,
    ObjectName = DB_NAME(st.dbid) + '.' + OBJECT_SCHEMA_NAME(st.objectid, st.dbid) + '.' + OBJECT_NAME(st.objectid, st.dbid),
    DatabaseName = (select TOP 1 DB_NAME(convert(int, value)) from sys.dm_exec_plan_attributes(cp.plan_handle) WHERE attribute IN ('dbid', 'dbid_execute') and value <> 32767 ORDER BY attribute),
    cp.usecounts,
    cp.size_in_bytes,
    qs.last_execution_time,
    qp.query_plan,
    sql_text = st.text,
    cp.plan_handle
FROM sys.dm_exec_cached_plans cp
  CROSS APPLY sys.dm_exec_sql_text(cp.plan_handle) st 
  CROSS APPLY sys.dm_exec_query_plan(cp.plan_handle) qp
  LEFT JOIN (SELECT 
                plan_handle, 
                last_execution_time = MAX(last_execution_time)
             FROM sys.dm_exec_query_stats 
             GROUP BY plan_handle) qs ON qs.plan_handle = cp.plan_handle
WHERE st.text like @query_text ESCAPE '\'
  AND st.text not like '%FBC03230-87F5-4D53-9BE4-26131E04F62E%' -- exclude itself
OPTION(MAXDOP 1, RECOMPILE)