Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “googol” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

157 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
googol83584(None) 
googols935481googols
gogo69722832g_ogo_
gogos77516522g_ogos
googly11417882googly
gooral7310462gooral
gorgon8310242gorgon
mongol94912532mongol
argol65317263_argol
bongo85720943bongo_
bongos95316653bongos
booboo1039463booboo
boocoo1039003boocoo
booger94816553booger
boogey124711523boogey
boogie93515993boogie
boogy114518323boog_y
boohoo1148833boohoo
bookoo1248343bookoo
cogon89120903_cogon
congo85623133congo_
congos94219883congos
congou94313243congou
consol82614113consol
coocoo1069693coocoo
cool66940493_co_ol
diobol936883diobol
doggo84410703doggo_
dongola945473dongola
doodoo8108893doodoo
doowop1283853doowop
drool65416103dro_ol
fodgel1136413fodgel
fool75330593_fo_ol
forgo94418333forgo_
forgot104318133forgot
formol112910333formol
gambol1138223gambol
gaol56925413g__aol
gasohol1143533gasohol
ghoul959053gho_ul
gigolo836533g_igolo
gigot74023073g_igot
gingal81010153gingal
girosol885303girosol
global937663global
glogg837353glog_g
gloggs935033gloggs
gloom87116523glo_om
glycol1254933glycol
gnomon936183gnomon
goal55829303g_o_al
gobo76126903g_obo_
gobos86219383g_obos
godson857383godson
goggle94511573goggle
goggly12337053goggly
gombo105814043gombo_
gombos114311093gombos
gondola946663gondola
gong66827193gong__
gonged97115913gonged
gongs74921613gong_s
gonion73612833gonion
gonof95218653g_onof
gonzo15310243gonzo_
goo47754773g_o_o_
goober93911743goober
good66531803g_o_od
goodby13406283goodby
goodie83613993goodie
goodly11419303goodly
goods75124483goo_ds
goody105620393goo_dy
gooey95522863goo_ey
goof85436873g_o_of
goofed114911383goofed
goofily14105353goofily
goofs94821003goo_fs
goofy124915623goo_fy
gooier73516213gooier
gook96429603g_o_ok
gooks105422883goo_ks
gooky135818033goo_ky
goon57236173g_o_on
gooney106612313gooney
goonie73615563goonie
goons65326773goo_ns
goony95519783goo_ny
goop75829483g_o_op
goops86620963goo_ps
goopy115816623goo_py
goorals838703goorals
goos57644913g_o_os
goose65925903goo_se
goosed86817033goosed
gooses75723053gooses
goosey105913513goosey
goosy96018883goo_sy
goral65125753g_oral
gorge76423893gorg_e
gorged95016983gorged
gorger86116983gorger
gorges85321893gorges
gorget87123863gorget
gorgons938853gorgons
gospel936533gospel
gouge78220063goug_e
gouged96214593gouged
gouger86014363gouger
gouges86318693gouges
grego7310523grego_
gregos847533gregos
grog65923343grog__
groggy1234803groggy
grogs76319413grog_s
groom85317983gro_om
grovel104310543grovel
growl96115823gro_wl
hoodoo10109983hoodoo
hoopoe11911233hoopoe
hoopoo1198753hoopoo
hoosgow1442763hoosgow
isogon7227543isogon
koodoo11107773koodoo
logo57931763_logo_
logoi69715943_logoi
logon615922313_logon
logos67225333_logos
mogul8310213_mogul
mongo810122413mongo_
mongoe94214983mongoe
mongols103310823mongols
mongos94318623mongos
mool67533863_mo_ol
noogie73612313noogie
obol65220613__obol
osmol7138573_osmol
podsol946853podsol
podzol1835083podzol
polyol1138713polyol
pool65835953_po_ol
shool84523153sho_ol
snool55118643sno_ol
sokol94612293_sokol
solgel737963solgel
sorgo64719723sorgo_
sorgos74514663sorgos
sotol54917653_sotol
spool75219043spo_ol
stool55619893sto_ol
toluol636903toluol
tool46735683_to_ol
trogon73611753trogon
voodoo10127533voodoo
wool76427373_wo_ol
zoonal1558083zoonal

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.390458182.1
2DLD Change Limit1127161575.61020092.0
3Display Results1571570.0463413.0
 (SQL Overall)1786911576.04629555.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.