Swindon is not a village, it’s a fairly large town. About 180,000 people live there. It is a very old town that has a slightly undeserved reputation for being grey and boring and too far from anywhere fun.
Sandford is inspired by Wells and Wimbourne, though neither of those are villages either. Wells is tiny, but actually a city.