Case File #9
The Adventure of the Indoctrination Proclamation
From the original Conan Doyle stories, the only indication that we get that Sherlock Holmes has actual carnal desires is the case of “A Scandal in Bohemia” where he encounters THE woman, Irene Adler. And even then, it's played off more as a fascination because she was able to fool him.
It's actually kind of unusual in the detective genre because often times, the lead is seduced by a potential client leading to all sorts of emotional entanglements throughout the mystery.
All this to say that I actually don't think Holmes knows what the hell he's talking about.