Excel - Compare 2 non identical columns (few words identical)

I have 2 files with large number of companies names. The names of the companies are written with different ways. I need someone with very good excel skills to create a formula or a way to find similar words within few hours. You have to be really good with excrl. The task can not be done manually