Removing slightly different overlapping geometries in QGIS/SQL

I am working on a large map in QGIS that is using 40′ wide street approximations to visualize a small city. The data is also held on an SQL server that I have access to. I am taking over the work from a previous employee who has made an error that is causing slow loading of this map. Each geometry has up to three copies of itself loaded on top of itself. This overlap is causing large slowdowns, as this is on nearly every polyline. As well, these overlapping polylines are not exact copies of each other, making it incredibly difficult to find the overlaps, let alone remove them. Is there a way to remove this overlapping geometry? I have attempted to use Delete Duplicate Geometries but since the geometries are not exact copies, it does nothing. I have attached pictures below to give a clearer picture of the issue I am having.

This is an image of one set of geometries.

This is an image of a second set of overlapping geometries. Notice the very minor differences that stop me from using Delete Duplicate Geometries.

I am able to use SQL Queries to manipulate this data as well if that would be an easier solution.