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

240 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
holds9462324(None) 
aholds10469481aholds
bolds85825281bolds
colds85726971colds
folds95221691folds
golds75421311golds
hods87239861ho_ds
hold86235061hold_
holes84748651holes
holks124720561holks
holms105117801holms
hols76946291hol_s
holts85627911holts
hoods95124081hoods
molds85324831molds
olds55926571_olds
wolds95420181wolds
ahold94714252ahold_
balds85524642balds
beholds1336422beholds
bods76244712bo_ds
bolas74733762bolas
bold75432812bold_
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bonds86126842bonds
cholas114818002cholas
cholos114716852cholos
chords125214632chords
clods85320862clods
cods76848102co_ds
coeds85920162coeds
colas75436772colas
cold77338772cold_
coles76055062coles
cols66553082col_s
colts76633292colts
cords86030622cords
dholes104914792dholes
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
elds56324852_elds
fold86528942fold_
folks126017122folks
fonds95824822fonds
foods95924162foods
fords95328182fords
gelds75118342gelds
gilds75417522gilds
goads77022852goads
gods65438042go_ds
gold65430162gold_
golfs95616102golfs
goods75124482goods
gowds105814042gowds
hales85449842hales
halids104016132halids
halls85633782halls
halms105225212halms
halos85230252halos
halts85230102halts
hands95327382hands
haoles94919802haoles
hards96435652hards
heads95127112heads
heeds95420422heeds
held85330402held_
hells85032042hells
helms105619462helms
helos84928062helos
helps105219342helps
herds96424682herds
hills85431352hills
hilts86924412hilts
hilus84817642hilus
hinds96721472hinds
hoards104912622hoards
hoars85925552hoars
hobos106321352hobos
hobs97038982ho_bs
hocks144925492hocks
hocus104715202hocus
hod76852462ho_d_
hodads1147962hodads
hoed87837982hoed_
hoers85724922hoers
hoes75755732ho_es
hoggs107212462hoggs
hogs87139662ho_gs
hokes126231642hokes
holards1148432holards
holden104113952holden
holder104619652holder
holders113715902holders
holdup1245182holdup
holdups1333592holdups
hole77553392hol_e
holed95634132holed
holey115626902holey
holies94630032holies
holism113713752holism
holist94723212holist
holk116027942hol_k
holla84918492holla
hollas94616902hollas
hollo84822162hollo
hollos95320632hollos
holly114824432holly
holm95628112hol_m
holp95727552hol_p
holt77852582hol_t
holy106333432hol_y
homes106938812homes
homos105921782homos
honda9414982honda
hondas10313352hondas
hones88144492hones
hongs95126202hongs
honks125124522honks
hons77350782ho_ns
hood85132332hood_
hoody124919722hoody
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoots84830252hoots
hopes105835642hopes
hops97942632ho_ps
horas86333102horas
horde94623052horde
hordes104921632hordes
horns86125332horns
hos68364192ho__s
hoses85443172hoses
hosts85526702hosts
hots78349332ho_ts
hounds104413132hounds
hours85422392hours
howdy155711412howdy
howes114730262howes
howfs144814502howfs
howks155016852howks
howls116219222howls
hows106345602ho_ws
hoyas115016162hoyas
hoyles12315012hoyles
hoys107733932ho_ys
hulas84920882hulas
hulks125715482hulks
hulls84923562hulls
hurds95219072hurds
hylas114815902hylas
hyoids1377672hyoids
joles125230832joles
jolts125018882jolts
kolas94822232kolas
kolos94921212kolos
loads65323372loads
loids66220702loids
lolls512121732lolls
lords64923502lords
melds84822382melds
milds86422052milds
mods77945052mo_ds
molas75132092molas
mold76034332mold_
moldy115014652moldy
moles74747922moles
molls75129782molls
mols65948572mol_s
molts76032092molts
moods85224622moods
moulds94910992moulds
nods55838222no_ds
nolos54423352nolos
odds68919922_odds
ods47546212_o_ds
old47033462_old_
oldy85316842_oldy
oles46453472_oles
ouds56430102_ouds
plods85719292plods
pods76540152po_ds
poles75351002poles
polis74731162polis
polls74627722polls
polos76129912polos
pols66044562pol_s
polys105718762polys
ponds85323402ponds
poods85124752poods
roads66523622roads
rods56442062ro_ds
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
roods65125282roods
scolds95011232scolds
silds65520522silds
sods54940212so_ds
sold54837412sold_
soldi65717202soldi
soldo67116562soldo
soles55547922soles
solids74116402solids
solos54830792solos
sols45448162sol_s
solus54726982solus
sords64527802sords
tholes94919782tholes
tholos94213002tholos
toads65621072toads
tods56141842to_ds
tolas54532772tolas
told56132202told_
toles55147132toles
tolls54728432tolls
tolus55024482tolus
upholds13135242upholds
velds95615582velds
voids95414672voids
voles86234042voles
volts85421292volts
welds94719162welds
wholes124616772wholes
wilds94818202wilds
woads94818442woads
woalds10427582woalds
wold85429072wold_
wolfs116214162wolfs
woods95723032woods
words95425072words
worlds10568732worlds
yods86531182yo_ds
yolks125412772yolks

Search took 5 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.610292936.1
2DLD Change Limit538002403.33016156.2
3Display Results2402400.1231951.2
 (SQL Overall)1786912404.06343980.1
 
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.