I want to be able to get a rough distance estimate between two cities as well as finding out all the cities that are X miles within a certain city.

I have a rough idea of how to do it using zip codes using the data from the Census Bureau, however I'm not sure how I would do this with cities.

Is there a free database somewhere that has the city, state along with the zip code near the middle of the city?