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

200 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
agendas93693(None) 
agenda837251agenda_
agendum1144672agendum
agendums1243442agendums
agenes74720252agen_es
agents74816292agen_ts
aggadas1055002aggadas
amends94713282amend_s
arenas65021992aren_as
augends935882augend_s
fazendas2143072fazendas
genoas74013622_genoas
lagends947272lagend_s
magentas1137922magentas
abelias93213573abelias
acedias1039773acedias
addenda10364463addenda_
addends10356053addend_s
adenomas1144813adenomas
adenyls1143923adenyls
aedes64625153a_e_des
aeneus61111143a_eneus
agamas97413453ag_amas
agas55938843ag___as
aged67334253age_d__
agedly1136463age_dly
agedness1036683agedness
ageings9437693ageings
ageisms1056603ageisms
ageists848493ageists
ageless8310343ageless
agencies1138743agencies
agency1237033agen_cy
agendaless1251593agendaless
agene65621583agen__e
ageneses939303ageneses
agenesias1045363agenesias
agenesis938043agenesis
agenize172910153agenize
agenizes18269743agenizes
agent65829643agen__t
agented939423agented
agential958153agential
agentry11165753agentry
agers65027853age__rs
ages55844593age___s
aggada955223aggada_
aggadah1362863aggadah
aggadahs1462263aggadahs
aghas97014873ag__has
agings86312673agin_gs
agitas7310593ag_itas
agmas85919873ag__mas
agonal7410053agon_al
agones75719863agon_es
agonies83016623agonies
agons66423783agon__s
agoras7613343ag_oras
agrias74315393ag_rias
akelas10311193ake_las
akenes104817343aken_es
alands75418373aland_s
alexias14249793alexias
algebras1143223algebras
amebas10311453ame_bas
amend85717753amend__
amended11328313amended
amender10349613amender
amenders11288353amenders
amens75624843amen__s
amentias1039413amentias
aments85219803amen_ts
anas46649863a__n_as
ands57833613a__nd_s
anemias92512143anemias
angas65827993a__ngas
anginas8310953angin_as
anlas55626933a__nlas
annas55824883a__nnas
anoas57226493a__noas
antas55432033a__ntas
antennas846403antennas
apneas83211383a_pneas
appends1236393append_s
areas55935773are__as
arecas84817443are_cas
arena55323813aren_a_
arenes64928393aren_es
arenous7314183arenous
areolas71013863areolas
arepas85515703are_pas
argental947933argental
argents84014853argen_ts
armadas1038173armadas
asanas6514113asan_as
ascends10388203ascend_s
atonias73315993atonias
attends8257593attend_s
augend837633augend__
avenges1157543avenges
avens86419333aven__s
avenses1049643avenses
avenues1057183avenues
bandas95120543_bandas
benday123810813_benday
bendays13327513_bendays
bends85628973_bend_s
bendys12518383_bendys
blendes104713683blendes
blends96012883blend_s
cadenzas2053743cadenzas
calendal1145383calendal
calendar1145013calendar
calendars1244523calendars
calends1039523calend_s
catenas9313113caten_as
centas85020703_centas
duendes938193duendes
duennas834143duennas
emends95711433emend_s
endash10297123__endash
ends56528523__end_s
eugenias947143eugenias
faenas94412763faen_as
fazenda2043253fazenda_
fends96324973_fend_s
fiends104110293fiend_s
galenas83310343galen_as
ganjas14149113_ganjas
geds66730813_ge_d_s
geladas936313_geladas
gelds75118343_geld_s
gender83517933_gender
genders93616783_genders
genes65133093_gen_es
genets75716663_genets
genevas1185253_genevas
genial74917613_genial
genies75324943_genies
genips9469943_genips
genius74512923_genius
genoa64315823_genoa_
genoms94412483_genoms
genres75515623_genres
genros74211333_genros
gens55740073_gen__s
gentes75324163_gentes
gents65729613_gen_ts
genua64614153_genua_
genus65319833_gen_us
geodes8412153_geodes
getas65421483_ge_tas
gonads84511733_gonads
haciendas1542083haciendas
haggadas1463633haggadas
hennas94211803_hennas
hondas10313353_hondas
hyenas1288953hyen_as
kalends1235683kalend_s
kendos114510663_kendos
khedas1446313khe_das
lagend838743lagend__
lagunas8156823lagun_as
legends936073legend_s
lends65326253_lend_s
maenads1037373maenads
magenta1038623magenta_
menads95514383_menads
mends84927693_mend_s
mensas85115863_mensas
naganas847983nagan_as
pagodas11367553pag_odas
pandas95521963_pandas
pends85527193_pend_s
rends65129953_rend_s
sageness92111983sageness
scenas84114703scen_as
scends95213003scend_s
sendal73314993_sendal
sendals81912273_sendals
sends65528243_send_s
sennas64214233_sennas
shends105313773shend_s
siennas736123siennas
spends94714473spend_s
taenias7311283taenias
tends65425583_tend_s
tendus75111183_tendus
tenias64720073_tenias
trends75513543trend_s
upends9438763upend_s
vaginas11298813vagin_as
vandas103915993_vandas
veenas91410413veen_as
vends95520893_vend_s
wakandas1643413wakandas
wends95822813_wend_s
whenas124610463when_as
xenias133712973_xenias
yentas94614213_yentas

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272006.28021341.9
3Display Results2002000.0633174.6
 (SQL Overall)1786912006.74926476.7
 
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.