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

250 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
cedes8492733(None) 
aedes64625151aedes
cades85440731cades
cede74928771cede_
ceded96118561ceded
ceder85322241ceder
ceders93817671ceders
cedis84317081cedis
cees65941591ce_es
cepes94424461cepes
ceres75540011ceres
cetes75731101cetes
codes86247291codes
pedes85327291pedes
redes65139131redes
accedes1237722accedes
aides65336602aides
bedel84219402bedel
bedels94015272bedels
bedew114513042bedew
bedews12398942bedews
beds75937782bed_s
bees65453382be_es
benes75536232benes
beses75830722beses
bides85536772bides
bodes84935102bodes
bredes94818472bredes
cade76443912cade_
cadet85339342cadet
cadets96316512cadets
cadges104716712cadges
cadis84428502cadis
cadres94017932cadres
cads76144522cad_s
cafes106426922cafes
cages85936012cages
cakes116037672cakes
cames97047312cames
canes75350372canes
capes95441922capes
cares77369182cares
cases75048382cases
cates75951892cates
caves105639702caves
cease75227652cease
ceases84427072ceases
cedar84014322cedar
cedars93312832cedars
cedi74919272ced_i
cee55952702ce_e_
ceils75019402ceils
celeb9314872celeb
celebs1037882celebs
cells75428062cells
cels65534972ce_ls
celts75325782celts
cense75121402cense
censes83721802censes
cents74730332cents
cepe84926652cepe_
ceps86125952ce_ps
cere66741472cere_
cered85227442cered
cereus85215522cereus
ceros74726072ceros
certes84623082certes
cess65326052ce_ss
cesses84221362cesses
cete64934782cete_
cheder125113492cheder
cheders134512392cheders
chides124620472chides
cider84723312cider
ciders94620092ciders
cines75239682cines
cires74932912cires
cites74435592cites
clades94920462clades
clepes104214622clepes
clues74623032clues
codas84724242codas
code77347732code_
codec107120342codec
codecs115112932codecs
coded95433182coded
coden86128542coden
codens94821012codens
coder86134222coder
coders95426982coders
codex155817582codex
cods76848102cod_s
coeds85920162coed_s
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
coses76949492coses
cotes76347842cotes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
credos94612852credos
creds85418772cred_s
creeds94714772creeds
cremes104517992cremes
crepes105419342crepes
cries75438402cries
crudes96218622crudes
cubes95028162cubes
cuds76730472cud_s
cues65438982c_ues
cukes115422092cukes
cures75645432cures
cutes79438322cutes
cyder114611132cyder
cyders12398832cyders
cyeses11510122cyeses
cymes1210118922cymes
deeds75423762deeds
dees56356632de_es
dekes105224452dekes
deles65139252deles
demes86032692demes
denes65639722denes
dexes135224512dexes
dudes75424372dudes
eches106322162eches
edges75718742_edges
edhs86212102_edhs
eds46638922_ed_s
ekes86726602_ekes
emes65434662_emes
eses45336102_eses
eves76230462_eves
ewes76328702_ewes
exes116530812_exes
eyes75837882_eyes
fades94932862fades
feces105625362feces
fedex1699602fedex
feds85234312fed_s
feeds94921142feeds
fees76450602fe_es
femes105626222femes
feres86038182feres
fetes85630142fetes
fezes175220022fezes
geds66730812ged_s
gees55647882ge_es
genes65133092genes
geodes8412152geodes
gledes84915132gledes
gudes74520812gudes
hades96035112hades
hebes105521672hebes
heder95623642heder
heders104119762heders
hedges115016262hedges
heeds95420422heeds
hemes105031082hemes
heres86245902heres
hexes155123042hexes
hides95129422hides
ides57734232_ides
jades135222112jades
jees115938542je_es
jefes155613672jefes
jetes124922842jetes
kedges124812982kedges
kexes166216822kexes
lades65141272lades
ledges84918012ledges
lees45455882le_es
leges64427292leges
lenes54738522lenes
leses54930812leses
leudes75314092leudes
lexes127225262lexes
lodes66436912lodes
ludes65728852ludes
meds75735362med_s
meeds84920272meeds
memes94927702memes
merdes94518602merdes
meres75143572meres
metes74736212metes
mezes167719262mezes
modes85537412modes
needs65719632needs
nenes55329672nenes
neves87021872neves
nides65229132nides
nodes64633492nodes
nudes64723292nudes
odes57243242_odes
peds75835242ped_s
pees65257372pe_es
pekes114623562pekes
peles75738082peles
penes75839222penes
peres76246642peres
recedes102816062recedes
redds74617832redds
rede55037672rede_
reded74829122reded
redoes74623772redoes
redos65126762redos
reds56042862red_s
redyes104214092redyes
reeds65430902reeds
rees45364192re_es
reges65628792reges
rexes124526952rexes
rides66140812rides
rodes614039082rodes
sades65239892sades
scenes84520352scenes
secedes103711982secedes
seder64826762seder
seders74420282seders
sedges83817812sedges
seeds64330062seeds
sees45361052se_es
semes75731582semes
seres55448892seres
sexes126126222sexes
sides65838362sides
suedes73918112suedes
swedes102711892swedes
teds54932572ted_s
tees45353582te_es
teles54536002teles
tides64830152tides
vees75439432ve_es
veges94118872veges
vexes155719122vexes
wades95634142wades
wedel94513962wedel
wedels103811032wedels
wedges114614582wedges
weds86628932wed_s
weeds95222212weeds
wees76249122we_es
wides94832822wides
yeses85119322yeses
zeds145821802zed_s
zees136331892ze_es

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.653273646.2
2DLD Change Limit538002502.75319542.3
3Display Results2502500.0604166.7
 (SQL Overall)1786912503.46651555.4
 
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.