Engage: F3 allows you to quickly and easily search for a string in the Text/HTML modules on your DotNetNuke Portal. The initial goal for the module was to make it easier for content administrators to find URLs that need replaced when moving a site from your Test environment to a Production environment, but the number of uses for Engage: F3 are limitless.
Recompiling the module fixed the open issue. https://github.com/EngageSoftware/Engage-F3/issues/7
The SQL query was very slow as the first query was looking for matches across all portals, in effect searching every HTML Content module.