I think its just taking longer to run the report with more query criteria. Try running it overnight or on weekend?
Dont' know how to run a direct sql query ask JamesNT
I use:
demographics / inactive = false
notes & encoutners / encounter date > 01/01/2021
street address <> xxx
state <>hi
zip <> 11111
city <> xxx
the report spits out the appropriate matches with address fields attached