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 “calender” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

185 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
calender113827(None) 
calendar1145011calendar
calenders1237401calenders
amender10349612_amender
blender104613842_blender
calendal1145382calendal
calendars1244522calendars
calendered1443392calendered
calenderer1342982calenderer
calends1039522calend_s
colander1139032colander
coleader1139182coleader
cullender1243552cullender
cylinder1433382cylinder
lavender1235142lavender
lender73921272__lender
slender83413592_slender
tailender1044072tailender
acceder1235363acce_der
alder65421913_al__der
alerter72111513_alerter
alexander1742773_alexander
aliener71011193_alien_er
aliner65621983_alin_er
almner85710723_almn_er
amended11328313_amended
amenders11288353_amenders
ascender1136733ascender
asunder856223_asunder
attender935913attender
avenger1135493_avenger
balancer1246603balancer
balder95318863bal__der
bander93928223ba__nder
bartender1244603bartender
bender95223303__bender
bilander1136673bilander
blander103715163_blander
bleeder10359643_bleeder
blende95413443_blende_
blended114710713_blended
blenders115210993_blenders
blendes104713683_blendes
blinder103912983_blinder
blonder104011943_blonder
blunder103813153_blunder
cadence1239063cadence_
cadenced1435523cadenced
cadences1338473cadences
calamander1553553calamander
calando1037383caland_o
caldera1037963cal__dera
caleche14297943caleche_
caleches15269933caleches
calendared1442593calendared
calenderers1452213calenderers
calendering1543473calendering
calendric1443483calendric
calendula1271973calendula
calenture1144303calenture
caliber1139733cal_iber
caliper11410963cal_iper
calker124917083cal__ker
caller85125483cal__ler
calliper1247513calliper
callower13159073callower
calmer105216933cal__mer
caloyer1238143cal_oyer
calypter1544063calypter
cameleer1246033cameleer
cancer104220923ca__ncer
candider1237343candider
candler103516593ca__ndler
candor94516423ca__ndor
caner75334773ca__n_er
canker124422523ca__nker
canner84625983ca__nner
cannier94014163ca_nnier
canoer85121073ca__noer
canter85230113ca__nter
caperer113013403cape_rer
caponier1237883caponier
carder94524183ca__rder
careener1039333careener
career85822243care__er
careerer1038583careerer
caresser1038813caresser
carpenter1346503carpenter
catenae9311373catenae_
caterer92815943cate_rer
cayenne1244603cayenne_
cayenned1443163cayenned
cayennes1345013cayennes
ceder85322243c__e_der
cementer1239193cementer
censer84516583c__enser
center84421413c__enter
challenger1652693challenger
cheder125113493c_he_der
cinder94119123c__inder
clanger104113493c_langer
cleaner93712303c_leaner
cleanser10356323c_leanser
clearer93710823c_learer
cleaver124110803c_leaver
clencher15277973c_lencher
clever114611533c_le_ver
clinger103812153c_linger
clinker133811663c_linker
cloner84418093c_lon_er
clowder13367943c_lowder
clunker13419453c_lunker
colanders1238013colanders
colder95121853col__der
coleaders1237823coleaders
collider113410423collider
colluder11276873colluder
commender16167923commender
contender1239563contender
cozener18328953cozen_er
cullenders1343193cullenders
cylinders1543203cylinders
damneder1243763damneder
dander811222993da__nder
darneder1033983darneder
daunder9348893da_under
defender1337293defender
degender1136893degender
emender10649843_emender
ender64325863___ender
engender1046633engender
expender18136843expender
extender16146333extender
fender103718723__fender
flenser1036783_flenser
flinder11319873_flinder
gander84322763ga__nder
gender83517933__gender
goaltender1252003goaltender
hander104526433ha__nder
inlander937223inlander
intender93310443intender
islander946103islander
kalends1235683kalend_s
lamenter1038863lamenter
lander74028483__lander
launder8309143la_under
lavenders1334753lavenders
leader74824653__leader
lenders84419643__lenders
lewder10479613__lewder
malanders1237023malanders
malinger11116533malinger
maunder10328683ma_under
mender93520793__mender
nakeder1254363nake_der
offender1543723offender
oleander936403_oleander
pander93725523pa__nder
pleader103511753_pleader
plunder103810503_plunder
ravener104110743raven_er
render74024143__render
sander74828533sa__nder
scalene9310773scalen_e_
scareder1135793scare_der
scavenger1542193scavenger
sender73824413__sender
silencer1036293silencer
silenter838873silenter
slander84015443_slander
sledder9399203_sledder
solander948123solander
spender103713693_spender
splendor1143753splendor
tailenders1143643tailenders
talented938423talented
tender74121843__tender
uplander1145533uplander
valence1268773valence_
valences1388513valences
vender103418423__vender
wakener1446913waken_er
wander104423713wa__nder
zander163417113za__nder

Search took 8 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621857.28320068.9
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.79522923.8
 
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.