You can use the INFORMATION_SCHEMA.TABLES system view:
SELECT * FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME LIKE '%Transaction%';
This of course begs the question of why you would have so many tables that you need a query to keep track of them. That many tables is a red flag concerning your database design...
Custom Apps, Inc.