A process we use at our link-building agency to weed out junk websites(or super big websites that would definitely not give you a link) from a list of prospects is using this formula in google sheets.
=ARRAYFORMULA(QUERY(A:A,”select * where not (“&TEXTJOIN(” or “,TRUE,”A contains ‘”&IMPORTDATA(“https://pastebin.com/raw/9K3zndkZ”)&”‘”)&”) label A’Filtered List'”))