Need a formula that will partial match data on multiple sheets

I have workbook that consists of three sheets SMC, DHA and List. I would like to Match certain columns in each sheet against another sheet. The problem is not all the company names are spelled the same between the three sheets. For example SMC could say Saint Mary Regional Medical Center. DHA could list the company as ST Mary RMC and List could say ST MARY RMC. Need an excel formula to match between 3 sheets and once partially matched return a result.

Thanks