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