How to write query for autocomplete suggestions

Question

Presently  i am using this query
select top 10 productname from  prpducts where productname like 'go%'

result:

Gold & Ivory Coloured Regal Bedspread
Gold & Ivory Duvet Set
Gold & Ivory Quilted Bedspread
Gold / Nickel Finished Christmas Bells
Gold / Silver Melting Furnace
Gold /Platinum Crucibles and Moulds for X-ray Fluorescence Analysis
Gold and Carat Balances with Electronic Anti-theft Code
Gold and Diamond Finger Rings
Gold And Diamond Jewellery
Gold And Red Colored Hindu Wedding Cards

But problem is ,i want different results
like


gold................
goat........
godrej.......
goods........
gown........
go nogo.........
gong.........
govia.........
god ganes........
golf...........

etc

so,please tell me the query format