Filter out values found in another table

I've got a table of keywords that indicate an email address is fake likeso:

Keywords

test

noemail.com

fake

I want to run it against another table that contains actual email addresses to remove email addresses that contain those trigger words (so they just need to contain the trigger words to be removed).

Here's an example of my table:

EmailAddress

[email protected]

[email protected]

[email protected]

[email protected]

The end product that I'm looking for:

EmailAddress

[email protected]

[email protected]

I'd also like to do vice versa where I show only fake values:

EmailAddress

[email protected]

[email protected]

I don't want to scrub them out in the query view as I need to keep them for reporting purposes (to display number of fakes).

Thank you in advance for the help, this community has been extremely helpful in the beginning of my PowerBI journey!