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 “holts” 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.

282 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
holts8562791(None) 
bolts76232111bolts
colts76633291colts
dolts65626311dolts
halts85230101halts
hilts86924411hilts
holds94623241holds
holes84748651holes
holks124720561holks
holms105117801holms
hols76946291hol_s
holt77852581holt_
hoots84830251hoots
hosts85526701hosts
hots78349331ho_ts
jolts125018881jolts
molts76032091molts
volts85421291volts
aholds10469482aholds
alts46639902_alts
belts75931162belts
bhoots11459912bhoots
blots75626172blots
boats75635152boats
bolas74733762bolas
bolds85825282bolds
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolt66254172bolt_
bolus79125542bolus
boots75837972boots
borts76735452borts
bots66453952bo_ts
botts75224862botts
bouts75131312bouts
celts75325782celts
cholas114818002cholas
cholos114716852cholos
chotts113610992chotts
clots75627642clots
coats75635002coats
colas75436772colas
colds85726972colds
coles76055062coles
cols66553082col_s
colt67158242colt_
coots75636842coots
costs77231142costs
cots68054842co_ts
cults75022552cults
delts65731792delts
dholes104914792dholes
doats65224882doats
doits66223672doits
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolt56649422dolt_
dots55647662do_ts
felts85324542felts
folds95221692folds
folks126017122folks
fonts86124752fonts
foots85528282foots
forts86034452forts
gelts65924612gelts
ghosts10489272ghosts
gilts64924262gilts
goats65527302goats
golds75421312golds
golfs95616102golfs
gouts64826172gouts
haets86525122haets
hafts116219462hafts
hales85449842hales
halls85633782halls
halms105225212halms
halos85230252halos
halt76056302halt_
hants86335402hants
haoles94919802haoles
harts88441592harts
hats76858252h_ats
heats85838402heats
hefts116218152hefts
hells85032042hells
helms105619462helms
helos84928062helos
helots95217702helots
helps105219342helps
hents87330742hents
hests85829932hests
hets75547202h_ets
hills85431352hills
hilt75850722hilt_
hilus84817642hilus
hints87330622hints
hists86328372hists
hits75545142h_its
hoars85925552hoars
hobos106321352hobos
hobs97038982ho_bs
hocks144925492hocks
hocus104715202hocus
hods87239872ho_ds
hoers85724922hoers
hoes75755732ho_es
hoggs107212462hoggs
hogs87139662ho_gs
hoist86433212hoist
hoists95516022hoists
hokes126231642hokes
hold86235062hol_d
hole77553392hol_e
holed95634132holed
holey115626902holey
holies94630032holies
holism113713752holism
holist94723212holist
holists104413962holists
holk116027942hol_k
holla84918492holla
hollas94616902hollas
hollo84822162hollo
hollos95320632hollos
holly114824432holly
holm95628112hol_m
holp95727552hol_p
holy106333432hol_y
homes106938822homes
homos105921792homos
hones88144492hones
hongs95126202hongs
honks125124522honks
hons77350782ho_ns
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoot75752102hoot_
hooty115022442hooty
hopes105835642hopes
hops97942632ho_ps
horas86333102horas
horns86125332horns
horst85833512horst
horsts95817512horsts
hos68364192ho__s
hoses85443182hoses
host77852832host_
hosta85917832hosta
hostas94515832hostas
hot67776062ho_t_
hotly115815482hotly
hours85422392hours
howes114730262howes
howfs144814502howfs
howks155016852howks
howlets13329222howlets
howls116219222howls
hows106345602ho_ws
hoyas115016162hoyas
hoyles12315012hoyles
hoys107733932ho_ys
hulas84920882hulas
hulks125715482hulks
hulls84923562hulls
hunts86826172hunts
hurts86922822hurts
huts76737442h_uts
hylas114815902hylas
jilts124717412jilts
joles125230832joles
jolt116639122jolt_
jolty155713032jolty
jots116336142jo_ts
kelts95222632kelts
kilts95122192kilts
kolas94822232kolas
kolos94921212kolos
lilts55822802lilts
lofts85518362lofts
lolls512121732lolls
loots55431422loots
lots47652092lo_ts
louts56330272louts
malts76331752malts
melts74930102melts
milts75430712milts
moats75827642moats
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mol_s
molt66356162molt_
molto75619602molto
moots75831662moots
morts75533562morts
mosts76028542mosts
mots66853162mo_ts
motts76527002motts
moults84713702moults
nolos54423352nolos
nowts86915862nowts
oats46554212_oats
olds55926582_olds
oles46453472_oles
oots46446442_oots
opts68124742_opts
orts46538332_orts
outs45746962_outs
pelts76128812pelts
phots105418502pho_ts
plots75025672plots
poets76024442poets
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
ports75934592ports
posts75228782posts
pots66452362po_ts
poults84613482poults
pouts75530322pouts
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
roots55933672roots
rotls55620162rotls
rots46454092ro_ts
routs57133412routs
salts55431882salts
shoats94117082shoats
shoots94619362shoots
shorts95321742shorts
shots84730852sho_ts
shotts93614702shotts
shouts94017722shouts
silts55330822silts
slots54830532slots
smolts84411882smolts
softs85019232softs
soles55547922soles
solos54830792solos
sols45448162sol_s
solus54726982solus
soots55536212soots
sorts54536662sorts
sots45552452so_ts
tholes94919782tholes
tholos94213002tholos
tilts55325612tilts
tofts84919242tofts
toits55327472toits
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
toots55331872toots
torts56138122torts
tots46654122to_ts
touts54830392touts
voles86234042voles
volt76439532volt_
volta85215622volta
volte85321302volte
voltes94915582voltes
volti84915962volti
welts85225192welts
wholes124616772wholes
whorts125111432whorts
wilts85023502wilts
wolds95420182wolds
wolfs116214162wolfs
wonts87621542wonts
worts88631182worts
wots76342892wo_ts
yolks125412772yolks

Search took 3 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 Filter178691538000.296603685.8
2DLD Change Limit538002821.60633499.4
3Display Results2822820.0803525.0
 (SQL Overall)1786912821.98290156.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.