SELECT Txt.query_text_id , Txt.query_sql_text , Pl.plan_id , Qry.* FROM sys.query_store_plan AS Pl JOIN sys.query_store_query AS Qry ON Pl.query_id = Qry.query_id JOIN sys.query_store_query_text AS Txt ON Qry.query_text_id = Txt.query_text_id WHERE Txt.query_sql_text LIKE '%SEARCH%’;