This video shows the size of the most known starships

Metaball Studios has compared the size of the most known starships.
It begins the Tie Fighter:

And there you have a lot of Star Trek starships:

And the biggest ships are from Halo: