The calculated distance (air line) between Madīnat an Naşr and Rosetta is approximately 106 miles respectively 171 kilometers.
By car or train, the actual journey to Rosetta is certainly longer, as only the direct route (as the crow flies) between Madīnat an Naşr and Rosetta has been calculated here.
Air line (approximately)
171 kilometers
92 nautical miles