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