How to detect a WordPress URL without doing a full HTTP GET

In this WordPress Stack Exchange question and answer, Jeff Atwood – co-founder of Stack Overflow – asks an interesting question in relation to WordPress and WP Super Cache and Rarst provides the answer as to why.