I think we have to remember here that for early censii (censuses?) peoples literacy was sadly lacking. I have found many cases of name spelling changing over the census decades, sometimes changing the initial letter of a first name making later alphabetical listing haphazard. Here is a description of how the data was collected, from
https://www.british-genealogy.com/resources/census/
"In many cases, the original schedule was filled in by a child rather than by the head of the household. The reason is simple. During the 1800s the children went to school, or Sunday school, and learned to read and write, whereas parents (of the older generation) could often not be able to read and write.
It is a common
myth that a census enumerator knocked on doors and asked who was present, and then wrote down the details, often mis-hearing, or mis-spelling. No. Sure, there may have been isolated examples of that having been done, but this is very rare!
During the week following census night, the enumerator visited all of the houses, and collected the forms. (The Schedules), and then he collated them, and
then wrote them up into his enumerator's book, in schedule number order. The enumerator may have found it difficult to interpret the handwriting on the schedule, and he may have mis-transcribed some details.
The original Schedules (forms) have very rarely survived. A pity, because it is those that are the
original records, albeit not the official ones."
Also where multiple names are used, which one is the 'used' one? In my own family, in recent past generations, it was usually the second name which was the used one - George Ernest was known as Ernest: Frank George was known as George: Millicent Eileen was known as Eileen. My father was Clifford Roy, known as Roy. I am different in that being named Lloyd Roy, I am known as Lloyd. If my second name had been
different to my father's, that may have been my 'known' name.