I have a list of around 150,000 domain names and I need to extract all the ones containing specific words. I have a list of 10,000 words that need to be searched for in these domain names.

Here is a short example:

List of domains

soccertraining.com
basketballguide.com
carrepair.com
localjobs.com
footballfan.com
vacationplanner.com
tennisteams.com

Say I want to extract all the domains containing "soccer", "basketball", "football", and/or "tennis".

This is the result I'm looking for:

soccertraining.com
basketballguide.com
footballfan.com
tennisteams.com

---

Can this be done with excel? I imagine there is a formula to do this but it may be difficult to run it on this large of a scale.

If anyone could help me with this I would really appreciate it!