Very similar domain names

Copy SQL

CREATE EXTENSION IF NOT EXISTS fuzzystrmatch;
WITH domains AS (SELECT domain_schema, domain_name
FROM information_schema.domains
WHERE domain_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL))
SELECT d1.domain_schema AS domain1_schema, d1.domain_name AS domain1_name,
d2.domain_schema AS domain2_schema, d2.domain_name AS domain2_name
FROM domains AS d1, domains AS d2
WHERE NOT (d1.domain_schema=d2.domain_schema AND d1.domain_name=d2.domain_name)
AND translate(d1.domain_name,'0123456789','')<>translate(d2.domain_name,'0123456789','')
AND levenshtein(d1.domain_name,d2.domain_name)<=1
ORDER BY domain1_name, domain2_name;

DROP EXTENSION IF EXISTS fuzzystrmatch;