Which celestial body impacts tides the most

the sun is almost 390 times farther away from the Earth than is the moon, its high mass still affects the tides. Because the Earth's surface is not uniform, tides do not follow the same patterns in all places.

The effect of distance on tidal forces is seen in the relationship between the sun, the moon, and the Earth's waters. Our sun is 27 million times larger than our moon. Based on its mass, the sun's gravitational attraction to the Earth is more than 177 times greater than that of the moon to the Earth.