Suggestion for Optimizing This SQL for Fixing Spelling

[thecoalman]

I'm trying to build SQL only spelling/title "fixer" and this is as far as I've been able to get with the help of ChatGPT. I have 20+ year old forum and the spelling mistakes are substantial, especially for earlier posts before spellcheck became a thing.

MariaDB 10.11

This is the block for words always capitalized, titles etc.

bad_low = the target word forced to lower case e.g. new york, ny
title_case = the correct case e.g. New York, NY

I know there will be a lot of things missed but it will fix most of the matches and is 100% phpBB safe, If I can reduce this to one update that would be great.

-- ############################################
-- # BOUNDARIES & PUNCTUATION
-- ############################################
SET @left = '(^|[ \n]|<br/>|<t>|<r>)';
SET @right = '($|[ \n]|<br/>|</t>|</r>)';
SET @punct_unit = '(?:[.,!?:;()\-]|&lt;|&gt;|&amp;)';
SET @punct_opt = CONCAT(@punct_unit, '*');
SET @punct_2p = CONCAT(@punct_unit, '{2,}');

-- #########################################################
-- # TITLE CASE UPDATES (4 patterns, separate updates)
-- # Converts any occurrence of bad_low (any case) to title_case
-- # Handles punctuation and boundaries on left, right, or both sides
-- # Skipped entirely if @use_title_case = 0
-- #########################################################

-- 1) Normal boundaries (optional punctuation)
UPDATE phpbb_posts p
JOIN nepa_forum_dictionary d ON d.bad_low = @bad_low
SET p.post_text = REGEXP_REPLACE(
 p.post_text,
 CONCAT('(?i)', @left, '(', @punct_opt, ')', d.bad_low, '(', @punct_opt, ')', @right),
 CONCAT('\\1\\2', d.title_case, '\\3\\4')
)
WHERE @use_title_case = 1
 AND d.title_case IS NOT NULL
 AND @forced_processed_update_now = 0;

-- 2) Right-side 2+ punctuation
UPDATE phpbb_posts p
JOIN nepa_forum_dictionary d ON d.bad_low = @bad_low
SET p.post_text = REGEXP_REPLACE(
 p.post_text,
 CONCAT('(?i)', @left, '(', @punct_opt, ')', d.bad_low, '(', @punct_2p, ')'),
 CONCAT('\\1\\2', d.title_case, '\\3')
)
WHERE @use_title_case = 1
 AND d.title_case IS NOT NULL
 AND @forced_processed_update_now = 0;

-- 3) Left-side 2+ punctuation
UPDATE phpbb_posts p
JOIN nepa_forum_dictionary d ON d.bad_low = @bad_low
SET p.post_text = REGEXP_REPLACE(
 p.post_text,
 CONCAT('(?i)', '(', @punct_2p, ')', d.bad_low, '(', @punct_opt, ')', @right),
 CONCAT('\\1', d.title_case, '\\2\\3')
)
WHERE @use_title_case = 1
 AND d.title_case IS NOT NULL
 AND @forced_processed_update_now = 0;

-- 4) Both sides 2+ punctuation
UPDATE phpbb_posts p
JOIN nepa_forum_dictionary d ON d.bad_low = @bad_low
SET p.post_text = REGEXP_REPLACE(
 p.post_text,
 CONCAT('(?i)', '(', @punct_2p, ')', d.bad_low, '(', @punct_2p, ')'),
 CONCAT('\\1', d.title_case, '\\2')
)
WHERE @use_title_case = 1
 AND d.title_case IS NOT NULL
 AND @forced_processed_update_now = 0;