How to delete rows by given values?

Question

excel

There is a file:
https://yadi.sk/d/VgxHe7R1uFe85
The first sheet contains links to the site and page titles.
The second sheet contains stop words.
Task:
Delete all lines from sheet 1 according to the given stop words from sheet 2.
For reference: there are about 100,000 lines in the first sheet. In the second about 9000 . All stop words are exactly in the first sheet. And repeat 1 time.
Does anyone have any ideas how to do this?

Answer 1

If the length of the words does not exceed 255 characters, then you can
add a column to sheet 1 with the formula: =IFERROR(MATCH(Sheet2!A:A; Sheet1!B1); 0)
Then select all rows for which this formula returns a value > 0 and remove them.

Answer 2

VBA
procedure is trivial
1. take a word from the 2nd sheet
2. find all occurrences on the first sheet and delete them
3. goto 1.