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