Similar to drunk goggles but in this case no alcohol involved. When one goes without sex for an extended period of time and the less attractive start looking better.
Can you believe the girl Steve went home with!? Must've been a serious case of Drought Goggles.