Here is a way to search the Information_Schema to find all tables that have the letter 't' in them, can be helpful to search the metadata of your database schema

 

select *

from INFORMATION_SCHEMA.columns

where table_name like '%t%'

order by column_name