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

143 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
ceders9381767(None) 
cedars93312831cedars
ceder85322241ceder_
cedes84927331cede_s
cheders134512391cheders
ciders94620091ciders
coders95426981coders
cyders12398831cyders
heders104119761heders
seders74420281seders
acceders1334792acceders
adders84315702adders
aedes64625152aede_s
aiders74524632aiders
alders74218422alders
beaders104120182beaders
bedders113513382bedders
bedels94015272bedels
bedews12398942bedews
beers75628392be_ers
benders104021062benders
biders94822802biders
cabers105023922cabers
cades85440732cade_s
cadets96316512cadets
cadgers114712002cadgers
cadres94017932cadres
cagers95624192cagers
caners84629202caners
capers105428142capers
carders104820352carders
carers85133962carers
caters85336502caters
cavers115026842cavers
cedar84014322cedar_
cedarn9408442cedarn
cedary12419602cedary
cede74928772cede__
ceded96118562cede_d
cedis84317082ced_is
cees65941592ce_e_s
ceilers93912532ceilers
celebs1037882celebs
celery1139622celery
censers94313902censers
centers94420602centers
cepes94424462cepe_s
ceres75540012cere_s
cereus85215522cereus
cetes75731102cete_s
cheder125113492cheder_
cheers114518912cheers
chewers154111142chewers
chiders135312942chiders
cider84723312cider_
cinders104617762cinders
citers85022982citers
codders114114452codders
codecs115112932codecs
codens94821012codens
coder86134222coder_
codes86247292code_s
codgers115113932codgers
comers105328082comers
cooers84324562cooers
copers104629842copers
corders104520882corders
corers85231072corers
covers114627962covers
cowers114625532cowers
criers83918582criers
cubers105318352cubers
curers84923192curers
cyder114611132cyder_
deers64930522de_ers
defers105116942defers
deters74724682deters
edgers84413922_edgers
egers65120372_egers
eiders74321362eiders
elders74817302elders
enders74324052enders
ewers86018822_ewers
eyers86521332_eyers
faders105117462faders
feeders113712862feeders
fenders113717262fenders
fevers125414892fevers
gelders93812572gelders
genders93616782genders
headers113819392headers
heder95623642heder_
hedgers124310262hedgers
heeders114213742heeders
herders113914122herders
hewers123715272hewers
hexers165612752hexers
hiders104919652hiders
jeers124818132je_ers
laders74927762laders
leaders83819602leaders
ledgers94912182ledgers
leers54828982le_ers
legers74518312legers
lenders84419642lenders
lepers84817322lepers
levers94621322levers
melders103213912melders
menders103818802menders
meters85625832meters
needers84111902needers
orders74315992orders
pedes85327292pede_s
pedlers103013272pedlers
peers75130272pe_ers
peters86624592peters
readers83823772readers
redders93615342redders
redears82814452redears
redes65139132rede_s
refers93921082refers
renders83821672renders
revers94529632revers
riders74123902riders
seceders11277962seceders
seder64826762seder_
seeders83017112seeders
seers55136382se_ers
senders83022352senders
severs94121122severs
sewers94719722sewers
tedders94010232tedders
tenders83719722tenders
udders83911292udders
veers84521362ve_ers
venders113717002venders
vexers165210402vexers
waders109120642waders
webers11310942webers
wedders123610722wedders
wedels103811032wedels
weeders113412932weeders
welders113313412welders

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 Filter178691825510.343520965.0
2DLD Change Limit825511432.40634310.5
3Display Results1431430.0463108.7
 (SQL Overall)1786911432.79563932.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.