I have prescription co-codamol for period pains which I took before my first colposcopy yesterday (hoping to numb the pain pre-emptively and also make me feel a bit distant). I don't have anything to compare it with to say it helped but I was ok with it, much more comfortable than any smear I've had. By the end my legs were shaking but the nurse said it's completely normal.
I also read on here a tip to relax being to relax your belly and put your hands on it...did the trick for me too when I was getting a bit anxious.
I totally dread smears as I have an awkwardly placed cervix but the consultant doing the colposcopy was a million times better with it.
Hope that helps xx