Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table my_table (doctor text);
insert into my_table values
('dr^abracadabra'),
('Dr. Abarth'),
('Dr.!Abarth'),
('Dr.^Abarth'),
('Dr, Abarth'),
('Dr,!Abarth'),
('Dr,^Abarth'),
  
('dr.Abraham'),
('dr,Abraham'),
('dr!Abraham'),
('dr Abraham'),
('dr^Abraham'),
  
('Ms. - Abbie'),
('Ms. _ Abbie'),
('badr! abSHOULD NOT MATCH'),
('SHOULD NOT ab MATCH'),
('SHOULD NOT MATCHab'),
('SHOULD NOT MATCH');

CREATE TABLE

INSERT 0 18

SELECT DISTINCT Doctor 
FROM my_table
WHERE (LOWER(Doctor) SIMILAR TO 'dr[.,][ !^]ab%' 
       OR LOWER(Doctor) SIMILAR TO 'dr[., !^]ab%' 
       OR LOWER(Doctor) SIMILAR TO 'dr[., !^] _ ab%' 
       OR LOWER(Doctor) SIMILAR TO 'mr[.,][ !^]ab%' 
       OR LOWER(Doctor) SIMILAR TO 'mr[., !^]ab%' 
       OR LOWER(Doctor) SIMILAR TO 'mr[., !^] _ ab%' 
       OR LOWER(Doctor) SIMILAR TO 'ms[.,][ !^]ab%' 
       OR LOWER(Doctor) SIMILAR TO 'ms[., !^]ab%' 
       OR LOWER(Doctor) SIMILAR TO 'ms[., !^] _ ab%' 
       OR LOWER(Doctor) SIMILAR TO 'ab%');

doctor

Dr, Abarth

Dr,!Abarth

Dr,^Abarth

Dr. Abarth

Dr.!Abarth

Dr.^Abarth

Ms. - Abbie

Ms. _ Abbie

dr Abraham

dr!Abraham

dr,Abraham

dr.Abraham

dr^Abraham

dr^abracadabra

SELECT 14

SELECT DISTINCT Doctor
FROM my_table
WHERE Doctor ~* '^((dr|mr|ms)(([\.,][\s!^])|[\.,\s!^])(\s.\s)?)?ab';

doctor

Dr, Abarth

Dr,!Abarth

Dr,^Abarth

Dr. Abarth

Dr.!Abarth

Dr.^Abarth

Ms. - Abbie

Ms. _ Abbie

dr Abraham

dr!Abraham

dr,Abraham

dr.Abraham

dr^Abraham

dr^abracadabra

SELECT 14

--problems
SELECT DISTINCT Doctor
FROM my_table
WHERE Doctor ~* '(\y(dr|mr|ms)(([.,][ !^])|[., !^])( _ )?)?ab';

doctor

Dr, Abarth

Dr,!Abarth

Dr,^Abarth

Dr. Abarth

Dr.!Abarth

Dr.^Abarth

Ms. - Abbie

Ms. _ Abbie

SHOULD NOT MATCHab

SHOULD NOT ab MATCH

badr! abSHOULD NOT MATCH

dr Abraham

dr!Abraham

dr,Abraham

dr.Abraham

dr^Abraham

dr^abracadabra

SELECT 17