Comparing two csv by match string

Hello All,

I am trying to compare two csv together using powershell. My question is there a way where powershell can compare two csv files against each other as long as there is a matching word then it would allow it as in the file. For Example: 

Result.csv:

ulrich schnauss - ...Passing By

Vitamin String Quartet - Bad Romance

vitas - opera 2

Result2.csv:

OPERA?

Passing By

Bad Romance

Test

If Powershell able to match even if there are extra word or symbols? Such as opera would get pick up and match with result2.csv even if it has a ? or capitalize. 

Thanks!