To destroy the earth as in breaking it apart, that meteor would probably have to be huge. Nearly moon sized or larger most likely. It would simply be like two large rocks hitting each other at high velocity.
But if by “destroy the earth”, you mean kill all life on earth, then the meteor wouldn’t have to be very large (several hundred km large or so?) to release enough energy to cause disruption to the atmosphere (which is a very very thin layer compared to the size of the earth) Another scenario is a huge amount of fire and material into the upper atmosphere which could block the sunlight from a large part of the earth for many years and that would cause a “nuclear winter” that would kill most plant life and therefore most animal life as well.
Latest Answers