First, what’s your price range?
Small hands usually means small frame. That means you’d probably want less recoil. A semi-automatic with a smaller cartridge would help achieve that. I’d look at the Ruger 380 LCP (it’s quite small) or the Beretta Tomcat in .32ACP.
The Walther PPK (the James Bond gun) is almost pretty small and comfortable.
Most of these guns are relatively inexpensive and ammunition is also relatively cheap and plentiful.
Thanks for the information.