The calculated distance (air line) between Cologne and Speyer is approximately 129 miles respectively 208 kilometers.
By car or train, the actual journey to Speyer is certainly longer, as only the direct route (as the crow flies) between Cologne and Speyer has been calculated here.