All of NW's minimum connection times are listed here (click on "1. Is the "connect time" built into my reservation?").

I'd be comfortable with a 38 minute domestic connection at DTW unless it was the last available segment of the day to the destination and my plans upon arrival left me no margin for error.