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 “tool” with Change Limit: [1] [2]

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

271 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
tool4673568(None) 
cool66940491cool
fool75330591fool
mool67533861mool
pool65835951pool
stool55619891stool
toil46536281toil
toll45535261toll
too38965421too_
took86531071took
tools55325241tools
toom66532931toom
toon47740631toon
toot45958881toot
wool76427371wool
atoll57913922atoll
awol75620672awol
boil66335182boil
boll65634752boll
bolo65535952bolo
boo58163662boo_
boob85932582boob
book106836332book
boom87435672boom
boon67142172boon
boor66130682boor
boos67955032boos
boot67759372boot
bowl96827702bowl
coal66939252coal
coil66439652coil
col59360352_col
coo59566362coo_
coof96643272coof
cook107236932cook
cools75632632cools
cooly105525422cooly
coon67248942coon
coop87238652coop
coos67456492coos
coot67860382coot
cowl97530812cowl
diol57329132diol
dol47150652_dol
doll56632492doll
dooly94821802dooly
doom76430072doom
door56928512door
drool65416102drool
enol45823822enol
foal76630922foal
foil76433912foil
food86830572food
fools86824202fools
foot76248012foot
foul77027582foul
fowl105723632fowl
gaol56925412gaol
goal55829302goal
goo47754772goo_
good66531802good
goof85436872goof
gook96429602gook
goon57236172goon
goop75829482goop
goos57644912goos
hood85132332hood
hoof106036582hoof
hook116133282hook
hooly115022222hooly
hoop96129982hoop
hoot75752092hoot
howl107625692howl
idol56818632idol
jowl146120302jowl
koel84519942koel
kohl113911712kohl
kolo87026222kolo
kook75822602kook
loll46128382loll
loo38359822loo_
loof78141052loof
look87333472look
loom67035052loom
loon47344792loon
loop67835012loop
loos49051122loos
loot46955822loot
moil65534082moil
mol56654592_mol
moll66735702moll
moo58460512moo_
mood76332062mood
moola75117032moola
mools76027172mools
moon67140812moon
moor66628552moor
moos66051302moos
moot67653622moot
noel45226552noel
noil46133242noil
nolo46229312nolo
noo37154042noo_
nook85728492nook
noon47134622noon
obol65220612obol
oil37452052_oil
ooh67637092_ooh
oot311274692_oot
owl66228972_owl
pol56449382_pol
poll66332132poll
polo66236632polo
poo57757112poo_
pood75934322pood
poof95541662poof
pooh96027382pooh
pools74427702pools
poon67341262poon
poop86532812poop
poor65630222poor
poos65949112poos
retool63914482retool
roil46235292roil
roll46331652roll
rood56733002rood
roof75738832roof
rook85532032rook
room66235082room
root45655922root
rotl45029682rotl
shool84523142shool
snool55118642snool
soil46138822soil
sokol94612282sokol
sol37256622_sol
solo45538942solo
sook84933392sook
soon46240502soon
soot45761052soot
sotol54917642sotol
soul46435712soul
spool75219042spool
stood65517712stood
stook95218212stook
stools65117022stools
stoop75821542stoop
tael46030712tael
tail45443652tail
tall47240212tall
tao38358952tao_
taos45541002taos
taxol124011362taxol
teal45546502teal
teel46335802teel
tel35647902t_el
tell44934702tell
thiol87616042thiol
tho67433962tho_
thole85620842thole
thou76722212thou
til36350262t_il
till45941202till
tirl45029922tirl
to218858982t_o_
toad55830182toad
toby96322292toby
tod49457072t_od
tods56141842tods
tody86327212tody
toe310166852t_oe
toea46732332toea
toed56137042toed
toes46956442toes
toff105929902toff
toft77441652toft
tofu76921332tofu
tog410255042t_og
toga57027412toga
togs57242432togs
toile54626492toile
toils54527492toils
toit46353062toit
toke86738492toke
tola45236332tola
told56132202told
tole46052902tole
tolls54728432tolls
tolu45529152tolu
toluol636902toluol
tolyl84710092tolyl
tom514358052t_om
tomb89029652tomb
tome67543192tome
toms68343492toms
ton310265102t_on
tonal53724302tonal
tone46953742tone
tong56434352tong
tons46553052tons
tony75635152tony
tooled74918902tooled
tooler63818612tooler
toons55027532toons
tooth88020182tooth
tootle62613812tootle
toots55331872toots
top510560682t_op
tope65946382tope
toph96326872toph
topi67830392topi
topo66932402topo
topoi76018352topoi
topos75726392topos
tops66248122tops
tor39261682t_or
tora47545992tora
torc66333352torc
tore47359322tore
tori47542152tori
torn46044252torn
toro48045682toro
toros54336192toros
torot56139942torot
torr45630902torr
tors46157382tors
tort46967462tort
tory75840542tory
tosh74826812tosh
toss45637972toss
tost48351922tost
tot38884772t_ot
total55321822total
tote46643672tote
tots46654122tots
tour45530372tour
tout46753822tout
tow610557362t_ow
towel84920522towel
town76928702town
tows78545552tows
towy105325472towy
toy69655192t_oy
toyo76925452toyo
toyon86715672toyon
toyos87519142toyos
toys78036342toys
triol55521362triol
trod57627952trod
trog57628212trog
troll54416532troll
troop76417532troop
trooz145016152trooz
trop66833302trop
trot46351312trot
trow78031422trow
troy77429682troy
two67925832two_
twos76718022twos
viol76523592viol
woo66949802woo_
wood85329382wood
woof106532422woof
wools84421462wools
wooly114417672wooly
woos76238802woos
yowl105820952yowl
zoo126238912zoo_
zoom156722102zoom
zoon137326982zoon
zoos135828802zoos

Search took 2 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 Filter178691298720.0802233637.5
2DLD Change Limit298722710.92032469.6
3Display Results2712710.0634301.6
 (SQL Overall)1786912711.063168100.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.