SQL script to rename all the table names with new name if it containes required string in mySQL and MsSQL

I have one database with 100 tables in it. out of 100 some tables have name like House, House1, House2 , HouseXYZ and so on. Now I want to write a script in MySQL and MsSQL to replace the House with Home. So my database should be having the table name Home, Home1, Home2, HomeXYZ and so on.