Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “agenda” with Change Limit: [1] [2] [3]

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

268 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
agenda	8	3	725	(None)
agendas	9	3	693	1	agendas
addenda	10	36	446	2	addenda
aged	6	73	3425	2	age_d_
agency	12	3	703	2	agency
agendum	11	4	467	2	agendum
agene	6	56	2158	2	agen_e
agenes	7	47	2025	2	agenes
agent	6	58	2964	2	agen_t
agents	7	48	1629	2	agents
aggada	9	5	522	2	aggada
amend	8	57	1775	2	amend_
amends	9	47	1328	2	amends
arena	5	53	2381	2	aren_a
augend	8	3	763	2	augend_
augends	9	3	588	2	augends
fazenda	20	4	325	2	fazenda
genoa	6	43	1582	2	_genoa
genua	6	46	1415	2	_genua
lagend	8	3	874	2	lagend_
lagends	9	4	727	2	lagends
magenta	10	3	862	2	magenta
abed	7	97	3413	3	abe_d_
abelia	8	31	1440	3	abelia
aced	7	95	4088	3	ace_d_
acedia	9	3	1039	3	acedia
aceta	7	40	1735	3	ace_ta
acned	8	75	2067	3	acned_
addend	9	45	845	3	addend_
addends	10	35	605	3	addends
adenoma	10	4	540	3	adenoma
adenyl	10	3	502	3	adenyl
adnexa	14	3	367	3	adnexa
aecia	7	38	1928	3	a_ecia
aga	4	104	4723	3	ag___a
agama	8	58	1558	3	ag_ama
age	4	71	5433	3	age___
agedly	11	3	646	3	agedly
agee	5	62	4149	3	age__e
ageing	8	42	1340	3	ageing
ageings	9	43	769	3	ageings
ageism	9	6	880	3	ageism
ageist	7	3	1538	3	ageist
agendums	12	4	344	3	agendums
agenesia	9	4	598	3	agenesia
agenize	17	29	1015	3	agenize
agented	9	3	942	3	agented
agential	9	5	815	3	agential
agentry	11	16	575	3	agentry
ager	5	59	3584	3	age__r
agers	6	50	2785	3	age_rs
ages	5	58	4459	3	age__s
aggadah	13	6	286	3	aggadah
aggadas	10	5	500	3	aggadas
agha	8	74	1730	3	ag__ha
agin	5	61	3271	3	agin__
aging	7	70	2635	3	agin_g
agings	8	63	1267	3	agings
agita	6	3	1542	3	ag_ita
agma	7	76	2326	3	ag__ma
agon	5	65	3188	3	agon__
agonal	7	4	1005	3	agonal
agone	6	59	2455	3	agon_e
agones	7	57	1986	3	agones
agonic	9	35	1514	3	agonic
agons	6	64	2378	3	agon_s
agony	9	64	1565	3	agon_y
agora	6	9	1433	3	ag_ora
agreed	8	47	1250	3	agreed_
agria	6	55	1714	3	ag_ria
ahead	9	68	1705	3	ahead_
ahed	8	95	3625	3	ahe_d_
akela	9	3	1134	3	ake_la
akene	9	58	1866	3	aken_e
akenes	10	48	1734	3	akenes
aland	6	55	2641	3	aland_
alands	7	54	1837	3	alands
alexia	13	29	1046	3	alexia
algebra	10	4	304	3	algebra
ameba	9	3	1238	3	ame_ba
amen	6	67	3315	3	amen__
amended	11	32	831	3	amended
amender	10	34	961	3	amender
amens	7	56	2484	3	amen_s
ament	7	60	3654	3	amen_t
amentia	9	3	1015	3	amentia
aments	8	52	1980	3	aments
amnia	7	59	1864	3	a_mnia
ana	3	95	5983	3	a__n_a
and	4	72	4417	3	a__nd_
ands	5	78	3361	3	a__nds
anemia	8	26	1357	3	anemia
anenst	6	35	1498	3	anenst
anent	5	49	3184	3	anen_t
anga	5	68	3135	3	a__nga
angina	7	4	1313	3	angin_a
anna	4	55	2901	3	a__nna
anoa	4	56	3447	3	a__noa
ansa	4	59	2777	3	a__nsa
anta	4	68	3958	3	a__nta
antenna	7	4	638	3	antenna
aped	7	85	3815	3	ape_d_
apnea	7	34	1341	3	a_pnea
append	11	3	827	3	append_
appends	12	3	639	3	appends
area	4	58	4339	3	are__a
areca	7	56	1863	3	are_ca
arenas	6	50	2199	3	arenas
arene	5	53	2941	3	aren_e
arenes	6	49	2839	3	arenes
areola	6	8	1367	3	areola
arepa	7	56	1556	3	are_pa
argent	7	40	2366	3	argen_t
argental	9	4	793	3	argental
argents	8	40	1485	3	argents
armada	9	3	878	3	armada
asana	5	3	1548	3	asan_a
ascend	9	42	973	3	ascend_
ascends	10	38	820	3	ascends
asea	4	63	2718	3	ase__a
atonia	6	38	1651	3	atonia
attend	7	25	897	3	attend_
attends	8	25	759	3	attends
avenge	10	8	755	3	avenge
avens	8	64	1933	3	aven_s
avenue	9	5	795	3	avenue
awed	8	84	3603	3	awe_d_
awned	9	66	1595	3	awned_
axed	12	88	2961	3	axe_d_
axenic	15	42	1000	3	axenic
banda	8	52	2310	3	_banda
bend	7	64	3526	3	_bend_
benday	12	38	1081	3	_benday
bends	8	56	2897	3	_bends
bendy	11	50	1725	3	_bendy
blend	8	53	1745	3	blend_
blende	9	54	1344	3	blende
blends	9	60	1288	3	blends
cadenza	19	4	377	3	cadenza
caged	9	54	2636	3	cage_d_
calendal	11	4	538	3	calendal
calendar	11	4	501	3	calendar
calends	10	3	952	3	calends
catena	8	3	1248	3	caten_a
duende	8	3	692	3	duende
duenna	7	3	459	3	duenna
egesta	7	42	865	3	egesta
emend	8	62	1489	3	emend_
emends	9	57	1143	3	emends
end	4	68	3435	3	__end_
ends	5	65	2852	3	__ends
eugenia	8	4	771	3	eugenia
faena	8	50	1420	3	faen_a
fazendas	21	4	307	3	fazendas
fend	8	48	3297	3	_fend_
fends	9	63	2497	3	_fends
fiend	9	53	1298	3	fiend_
fiends	10	41	1029	3	fiends
frena	8	59	1527	3	fren_a
gaed	6	60	3151	3	gae_d_
gaen	5	73	2960	3	gaen__
gaged	8	55	2231	3	gage_d_
galena	7	49	1109	3	galen_a
ganja	13	14	1000	3	_ganja
garda	7	3	1676	3	_garda
ged	5	70	4453	3	_ge_d_
geds	6	67	3081	3	_ge_ds
geed	6	54	3550	3	_geed_
gelada	8	3	762	3	_gelada
geld	6	58	2843	3	_geld_
gelds	7	51	1834	3	_gelds
gemma	10	63	1177	3	_gemma
gen	4	59	5051	3	_gen__
gender	8	35	1793	3	_gender
gene	5	62	3722	3	_gen_e
genera	7	12	1171	3	_genera
genes	6	51	3309	3	_genes
genet	6	60	3868	3	_genet
geneva	10	8	585	3	_geneva
genial	7	49	1761	3	_genial
genic	8	51	1939	3	_genic
genie	6	61	2492	3	_genie
genii	6	45	1417	3	_genii
genip	8	44	1520	3	_genip
genoas	7	40	1362	3	_genoas
genom	8	37	1684	3	_genom
genre	6	60	1680	3	_genre
genro	6	49	1403	3	_genro
gens	5	57	4007	3	_gen_s
gent	5	69	5439	3	_gen_t
gents	6	57	2961	3	_gents
genu	5	59	2907	3	_gen_u
genus	6	53	1983	3	_genus
geode	7	4	1259	3	_geode
geta	5	66	2744	3	_ge_ta
gonad	7	52	1605	3	_gonad
gonia	6	41	1753	3	_gonia
hacienda	14	4	219	3	hacienda
haggada	13	5	364	3	haggada
henna	8	44	1404	3	_henna
honda	9	4	1498	3	_honda
hyena	11	8	1025	3	hyen_a
kalends	12	3	568	3	kalends
kendo	10	51	1322	3	_kendo
kheda	13	4	653	3	khe_da
laguna	7	12	722	3	lagun_a
legend	8	3	769	3	legend_
legends	9	3	607	3	legends
lend	5	62	3367	3	_lend_
lends	6	53	2625	3	_lends
maenad	9	3	941	3	maenad
magentas	11	3	792	3	magentas
menad	8	59	1898	3	_menad
mend	7	53	3403	3	_mend_
mends	8	49	2769	3	_mends
mensa	7	53	1867	3	_mensa
menta	7	44	2442	3	_menta
nagana	7	4	894	3	nagan_a
omenta	8	34	1172	3	omenta
paged	9	59	2678	3	page_d_
pagoda	10	48	787	3	pag_oda
panda	8	50	2261	3	_panda
pend	7	59	3453	3	_pend_
pends	8	55	2719	3	_pends
penna	7	45	2020	3	_penna
plena	7	58	1639	3	plen_a
pudenda	11	4	296	3	pudenda
raged	7	48	2945	3	rage_d_
ramenta	9	3	1118	3	ramenta
regna	6	46	1481	3	regn_a
rend	5	61	3657	3	_rend_
rends	6	51	2995	3	_rends
scena	7	48	1578	3	scen_a
scend	8	55	1629	3	scend_
scends	9	52	1300	3	scends
send	5	52	3729	3	_send_
sendal	7	33	1499	3	_sendal
sends	6	55	2824	3	_sends
senna	5	46	1798	3	_senna
sensa	5	41	1747	3	_sensa
shend	9	47	1997	3	shend_
shends	10	53	1377	3	shends
sienna	6	4	719	3	sienna
spend	8	56	1933	3	spend_
spends	9	47	1447	3	spends
spendy	12	49	1114	3	spendy
taenia	6	3	1319	3	taenia
tend	5	64	3377	3	_tend_
tends	6	54	2558	3	_tends
tendu	6	72	1600	3	_tendu
tenia	5	53	2448	3	_tenia
trend	6	48	1745	3	trend_
trends	7	55	1354	3	trends
trendy	10	46	960	3	trendy
upend	8	50	1104	3	upend_
upends	9	43	876	3	upends
vagina	10	27	1093	3	vagin_a
vanda	9	45	1592	3	_vanda
veena	8	19	1232	3	veen_a
vena	7	61	2629	3	_ven_a
vend	8	66	2642	3	_vend_
vends	9	55	2089	3	_vends
waged	10	48	2278	3	wage_d_
wakanda	15	4	401	3	wakanda
wend	8	53	3045	3	_wend_
wends	9	58	2281	3	_wends
xenia	12	48	1477	3	_xenia
yenta	8	39	1704	3	_yenta

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	112716	0.393	454684.5
2	DLD Change Limit	112716	268	5.450	20681.8
3	Display Results	268	268	0.080	3350.0
	(SQL Overall)	178691	268	5.923	30169.0