Try NOT to be offended. I have a really weird last name. There are only a few of us in the U.S. with this last name so most people are not used to hearing it. It’s pronounced exactly how it’s spelled, but almost no one pronounces it correctly if they see it spelled or even if they hear me say it (several times, and spell it repeatedly). The same goes for my street name.
So everytime I meet someone new, or have to give my name and address, I always try to nip the problem in the bud by saying the name (then slowly spelling it) then saying the street name (then slowly spelling it) and realizing that most people are still going to get it wrong. It happens all the time, so I’ve gotten used to it. I don’t think that anyone is trying to offend me, they just can’t figure it out for some reason.
My dad has it worse, because his first name is something like Joe, but that is his real full first name (not short for Joseph or anything else) then he has to explain the weird last name thing, and then the weird street name thing.
We get mail addressed to everyone except our real last name. But since it happens so often, we just guess that people are not very good spellers, they don’t understand pronunciation if it’s not super-easy, and they really don’t listen all that much, because they are wired to expect a different answer. So we try not to hold it against anyone and just keep on repeating the same stuff over and over again.
In your case, you should figure out what your pat answer will be and just memorize it like a mantra and don’t give any thought to offense. Most people are just trying to make conversation, some might have a relative who’s name is Joe (but is short for Joseph) and others just can’t spell or comprehend things that don’t fit the mold of what they expect. I would guess it would be a very rare occurrence that someone is actually trying to offend you on purpose.
I think this problem is similar (but not in such a dramatic way) to people that have visible disabilities. People are always asking questions about people’s disabilities, even though they shouldn’t, but I don’t think most people are trying to be rude. People’s brains are wired to expect certain things and when things don’t seem “right” , they often fall into the trap of asking stupid questions to help make sense of it.