if I get you right, you have defined items, separated by a semicolon? or is it undefined strings you want to compare like
That would make a different story, guess you would have to run loops on that. Ghastly.
As long as you can split up the items using a defined separator (";") as given in your sample, you may want to extract data (using the subfield command) into two tables, one for column 1 and one for the other, each with an id for the line and a field for the text.
The data would look like this:
Then, grouped per line_id, you count matches of both fields, here resulting in a sum of 1 for line_id 1 and 0 for line_id 2.
Any line with >0 matches is what you are looking for.