It does! In the same way that hitting your thumb with a hammer works as anesthetic when getting a tooth pulled.

Which is to say, at least it's a different kind of pain to focus on... (And, very slightly more seriously, sometimes if you can stop thinking about how stuck you are for a bit, ideas will start coming again.)
Off to try beating head on desk repeatedly and see if it helps...
Blackdragon, I hope you figure it out soon I know how frustrating it can be at times.