Which 2006 movie does Owen Wilson Matt Dillon and Kate Hudson play together involvinga house guest that stays too long?

The 2006 movie you're thinking of is You, Me and Dupree.

Owen Wilson plays the character of "Dupree", who is a house guest of the newly married couple played by Matt Dillon and Kate Hudson. Dupree overstays his welcome, causing a lot of comedic chaos.