I designed this to fix a broken hoover hose connector. Works fine and fits tightly on mine, no sanding etc needed. Feel free to modify. Looks shorter than some I've seen online, but this is only because the one I was modelling was of this size.
May need further refinement etc, this was a first draft and worked really well, but it's all up to you.