In Salesforce Marketing Cloud, this query finds records within the All Subscriber List. The records it finds are those emails addresses, which match the email within SomeDataExtension. There is an extra parameter to exclude a string.

AllSubscriberExclude.sql

SELECT sde.*

FROM SomeDataExtension sde

INNER JOIN _ListSubscribers l ON sde.SubKey = l.SubscriberKey

WHERE l.ListID = '000'
    AND sde.SubKey = l.SubscriberKey
    AND sde.Email = l.EmailAddress
    AND sde.Email NOT LIKE '%string here%'
    AND l.EmailAddress NOT LIKE '%string here%'