I had begun this question with frustration, but then accidentally stumbled upon the solution. 
If you wish to search for URL inside Confluence content, use the following regex expression syntax:
/.*{URL}.*/
For example, I wanted to find every Confluence reference to our deprecated Google Site, so I searched for: /.*sites.google.com.*/
JOY!