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

262 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
colds8572697(None) 
bolds85825281bolds
clods85320861clods
cods76848101co_ds
coeds85920161coeds
colas75436771colas
cold77338771cold_
coles76055061coles
cols66553081col_s
colts76633291colts
cords86030621cords
folds95221691folds
golds75421311golds
holds94623241holds
molds85324831molds
olds55926571_olds
scolds95011231scolds
wolds95420181wolds
acold86214932acold_
aholds10469482aholds
balds85524642balds
bods76244712bo_ds
bolas74733762bolas
bold75432812bold_
boles75448602boles
bolls75531312bolls
bolos75531372bolos
bolts76232112bolts
bolus79125542bolus
bonds86126842bonds
cads76144522c_ads
caids85226422caids
calfs104919382calfs
calks115421602calks
calls75634732calls
calms95222352calms
calos74431902calos
cards85137932cards
caulds95512382caulds
cells75428062cells
cels65534972cel_s
celts75325782celts
chads116122232chads
cholas114818002cholas
cholos114716852cholos
chords125214632chords
clads85722732clads
clod76124612clod_
clogs85519552clogs
clons75228132clons
clops95924852clops
clots75627642clots
clouds94612352clouds
cloys104916942cloys
coalas87418962coalas
coals76129602coals
coats75635002coats
cobbs115013992cobbs
cobles104622882cobles
cobs87043142co_bs
cocas95926572cocas
cocks135227162cocks
cocos95624692cocos
cod69660122co_d_
coda77029342co_da
codas84724242codas
code77347732co_de
codes86247292codes
coed77140542coed_
coffs134916302coffs
cogs77340032co_gs
cohos105921852cohos
coifs105718702coifs
coils75030082coils
coins75834552coins
coirs75221052coirs
cokes115537192cokes
col59360352col__
cola66541392col_a
colby124415062colby
colbys13407152colbys
colder95121852colder
coldest102514762coldest
coldish1399302coldish
coldly12459952coldly
cole66956112col_e
coleads102911422coleads
coled85540762coled
coleus86818272coleus
colic95726172colic
colics104219902colics
colies84837052colies
colin76231692colin
colins85229042colins
colly104926772colly
colog86619932colog
cologs96517352cologs
colon78630192colon
colons86028682colons
color76123742color
colors86622372colors
colt67158242col_t
coly96940532col_y
colza165112982colza
colzas174010512colzas
comas95833002comas
combs116122962combs
comes97246992comes
comps115526052comps
condo85322592condo
condos94322332condos
cones76457422cones
conks115525702conks
conns75024232conns
cons66057692co_ns
conus76726532conus
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492co_os
coots75636842coots
copes97747102copes
cops86751372co_ps
cord76740922cord_
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442co_rs
cos510270392co__s
coses76949492coses
coss66143492co_ss
costs77231142costs
cotes76347842cotes
cots68054842co_ts
coude85022632coude
could86517712could_
couldst1037042couldst
coulis84018762coulis
coups95522472coups
coves105539172coves
cowls106922212cowls
cows97046642co_ws
coxes145430862coxes
coys97537242co_ys
cozes166033242cozes
creds85418772creds
crowds124910762crowds
cruds85815852cruds
cuds76730472c_uds
culls75425812culls
culms95314192culms
cults75022552cults
curds85725612curds
doles67843752doles
dolls66126922dolls
dols56943052dol_s
dolts65626312dolts
elds56324852_elds
fold86528942fold_
folks126017122folks
fonds95824822fonds
foods95924162foods
fords95328182fords
gelds75118342gelds
gilds75417522gilds
goads77022852goads
gods65438042go_ds
gold65430162gold_
golfs95616102golfs
goods75124482goods
gowds105814042gowds
hods87239862ho_ds
hold86235062hold_
holes84748652holes
holks124720562holks
holms105117802holms
hols76946292hol_s
holts85627912holts
hoods95124082hoods
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
scalds94813692scalds
scold85414862scold_
silds65520522silds
sods54940212so_ds
sold54837412sold_
soldi65717202soldi
soldo67116562soldo
soles55547922soles
solids74116402solids
solos54830792solos
sols45448162sol_s
solus54726982solus
sords64527802sords
toads65621072toads
tods56141842to_ds
tolas54532772tolas
told56132202told_
toles55147132toles
tolls54728432tolls
tolus55024482tolus
velds95615582velds
voids95414672voids
voles86234042voles
volts85421292volts
welds94719162welds
wilds94818202wilds
woads94818442woads
woalds10427582woalds
wold85429072wold_
wolfs116214162wolfs
woods95723032woods
words95425072words
worlds10568732worlds
yods86531182yo_ds
yolks125412772yolks

Search took 4 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.466383457.1
2DLD Change Limit538002622.94018299.3
3Display Results2622620.0763447.4
 (SQL Overall)1786912623.48251318.5
 
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.