Probably not in the same league as your example, but ...
An ancestor of mine was born in 1829 in a village called Great Staughton in Huntingdonshire (according to the 1861 Census). I found him (and his family) easily enough in the 1871 Census, but I was 9an still am) unable to find him in the 1881 Census.
I eventually found him in the 1891 Census, where his 'place of birth' details says "Storton, Hunts". It took me a while to realise that this was the correct person. I would imagine that on census night, when the Census bloke asked my GGF where he was born, the Census bloke didn't know how to spell it, so simply spelt it just how it sounded.