Although that method is undocumented and may not be the best for production purposes I like to use it anyway.

 EXEC sp_MSforeachtable 'if PARSENAME("?",1) like ''%CertainString%'' DROP TABLE ?'