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

Here are the results of your fuzzy-string dictionary search for “azalea” 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.

307 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
azalea	15	3	700	(None)
azaleas	16	3	699	1	azaleas
azole	14	51	1803	2	azole_
azoles	15	46	1461	2	azoles
galea	6	47	2293	2	_galea
palea	7	50	2866	2	_palea
aahed	9	178	1644	3	a_ahed
aal	3	90	5867	3	a_al__
aalii	5	3	1613	3	a_alii
aals	4	99	4114	3	a_al_s
abaca	9	51	1804	3	aba_ca
abaka	11	43	1382	3	aba_ka
abase	7	60	2348	3	abase_
abased	9	65	1499	3	abased
abaser	8	64	1434	3	abaser
abases	8	57	2077	3	abases
abasia	8	7	1295	3	abasia
abate	7	66	2784	3	abate_
abated	9	59	1845	3	abated
abater	8	55	1812	3	abater
abates	8	58	2503	3	abates
abaya	10	44	1317	3	aba_ya
abele	7	63	2325	3	abele_
abeles	8	47	1939	3	abeles
abelia	8	31	1440	3	abelia
able	6	63	4053	3	a_ble_
abled	8	69	2683	3	a_bled
abler	7	56	2431	3	a_bler
ables	7	59	3554	3	a_bles
abolla	8	4	1019	3	abolla
abulia	8	35	1250	3	abulia
acacia	10	3	1135	3	acacia
acaleph	14	5	344	3	acaleph
aculei	8	3	979	3	aculei
adage	7	4	1405	3	adage_
adages	8	4	1295	3	adages
addle	7	43	1835	3	addle_
addled	9	41	1252	3	addled
addles	8	42	1660	3	addles
agama	8	58	1558	3	aga_ma
agapae	9	38	804	3	agapae
agape	8	56	1484	3	agape_
agapes	9	52	1241	3	agapes
agate	6	65	2515	3	agate_
agates	7	61	2134	3	agates
agave	9	53	1403	3	agave_
agaves	10	46	1151	3	agaves
agaze	15	61	1366	3	agaze_
agile	6	51	2226	3	agile_
agleam	9	15	862	3	a_gleam
aglee	6	57	2849	3	a_glee
aglet	6	55	3414	3	a_glet
agley	9	69	1733	3	a_gley
aiglet	7	42	2419	3	aiglet
ailed	6	62	4028	3	a_iled
aisle	5	52	2319	3	aisle_
aisled	7	45	1618	3	aisled
aisles	6	47	2114	3	aisles
akela	9	3	1134	3	akel_a
ala	3	124	6360	3	__al_a
alae	4	56	4375	3	ala_e_
alameda	10	3	549	3	alameda
alane	5	61	3561	3	alane_
alaska	10	3	671	3	alaska
alate	5	53	4032	3	alate_
alated	7	56	2514	3	alated
alates	6	48	3396	3	alates
alba	6	83	2833	3	__alba
ale	3	65	7234	3	__ale_
alec	6	64	3006	3	__alec
alee	4	66	5232	3	__alee
alef	7	63	4069	3	__alef
ales	4	70	6710	3	__ales
alfa	7	76	2427	3	__alfa
alfalfa	13	4	244	3	alfalfa
alga	5	79	2760	3	__alga
allee	5	49	3212	3	a_llee
alley	8	57	2167	3	a_lley
alma	6	63	3302	3	__alma
althea	9	3	819	3	althea
alula	5	3	1709	3	alul_a
alulae	6	3	1274	3	alulae
amalgam	12	4	492	3	amalgam
amarna	8	3	979	3	amarna
amaze	16	60	1660	3	amaze_
amazed	18	51	931	3	amazed
amazes	17	56	1347	3	amazes
amble	9	59	2464	3	amble_
ambled	11	51	1637	3	ambled
ambler	10	49	1645	3	ambler
ambles	10	51	2186	3	ambles
amole	7	57	2459	3	amole_
amoles	8	41	2219	3	amoles
ample	9	47	2030	3	ample_
ampler	10	43	1330	3	ampler
amulet	8	4	1957	3	amulet
anadem	9	3	918	3	anadem
anal	4	80	3752	3	anal__
analecta	10	4	573	3	analecta
analemma	12	11	389	3	analemma
analgia	8	9	836	3	analgia
anally	9	5	1350	3	anally
analog	7	15	997	3	analog
anele	5	56	2883	3	anele_
aneled	7	47	1927	3	aneled
aneles	6	46	2629	3	aneles
angle	6	45	2887	3	angle_
angled	8	42	1908	3	angled
angler	7	40	1786	3	angler
angles	7	44	2670	3	angles
anile	5	46	3446	3	anile_
ankle	9	52	2025	3	ankle_
ankled	11	43	1347	3	ankled
ankles	10	48	1838	3	ankles
anklet	10	56	1873	3	anklet
anole	5	53	3037	3	anole_
anoles	6	48	2742	3	anoles
antler	6	46	1555	3	antler
apace	9	47	1838	3	apace_
apnea	7	34	1341	3	a_pnea
apnoea	8	6	709	3	apnoea
apple	9	45	1767	3	apple_
apples	10	43	1576	3	apples
applet	10	59	1743	3	applet
arable	8	18	2100	3	arable_
arables	9	18	1497	3	arables
arame	7	50	2662	3	arame_
arames	8	46	2257	3	arames
area	4	58	4339	3	__area
argala	7	47	1267	3	argal_a
argle	6	54	2156	3	argle_
argled	8	53	1455	3	argled
argles	7	52	1848	3	argles
ariled	7	56	2032	3	ariled
arles	5	67	3574	3	a_rles
armlet	8	41	1819	3	armlet
asana	5	3	1548	3	asa_na
asea	4	63	2718	3	__asea
ashler	9	45	997	3	ashler
asyla	8	3	933	3	asyl_a
atalaya	10	4	482	3	atalaya
ataxia	13	17	959	3	ataxia
auklet	10	42	1683	3	auklet
availed	11	3	597	3	availed
awake	12	50	1478	3	awake_
awaked	14	57	920	3	awaked
awaken	13	46	886	3	awaken
awakes	13	50	1247	3	awakes
aware	8	64	2002	3	aware_
axal	11	65	2049	3	axal__
axile	12	60	2051	3	axile_
axilla	13	28	957	3	axilla
axle	11	64	2460	3	a_xle_
axled	13	53	1581	3	a_xled
axles	12	52	1947	3	a_xles
azan	13	65	2178	3	aza__n
azans	14	65	1688	3	aza_ns
azide	15	56	1716	3	azide_
azides	16	51	1380	3	azides
azine	14	67	2141	3	azine_
azines	15	55	1707	3	azines
azlon	14	43	1287	3	az_lon
azote	14	44	1634	3	azote_
azoted	16	38	859	3	azoted
azotes	15	43	1222	3	azotes
azulejo	23	4	148	3	azulejo
azure	14	9	1148	3	azure_
azures	15	5	1018	3	azures
bale	6	63	5384	3	_bale_
baled	8	54	3644	3	_baled
baler	7	56	3527	3	_baler
bales	7	62	5008	3	_bales
balsa	7	79	2041	3	_balsa
beflea	11	4	712	3	beflea
cabala	10	35	1691	3	cabal_a
calesa	8	4	1247	3	_calesa
calla	7	48	2707	3	_calla
canaled	10	36	1555	3	canaled
catalpa	11	3	650	3	catalpa
cavalla	12	5	788	3	cavalla
chaleh	14	37	1199	3	chaleh
chalet	11	38	2599	3	chalet
challa	11	40	1419	3	challa
coala	7	75	2112	3	coal_a
coaled	9	50	2270	3	coaled
coaler	8	41	2171	3	coaler
dale	5	56	4398	3	_dale_
dales	6	64	3974	3	_dales
dazzle	15	3	685	3	dazzle_
dazzled	17	3	503	3	dazzled
dazzler	16	3	471	3	dazzler
dazzles	16	3	641	3	dazzles
dealer	7	41	2214	3	dealer
deflea	10	3	744	3	deflea
dialed	8	47	1645	3	dialed
dialer	7	43	1543	3	dialer
flea	7	56	2849	3	__flea
foaled	10	45	1596	3	foaled
gala	5	56	3516	3	_gal_a
galatea	8	3	995	3	galatea
gale	5	63	4732	3	_gale_
galeae	7	47	1745	3	_galeae
galeas	7	46	1851	3	_galeas
galena	7	49	1109	3	_galena
gales	6	54	4248	3	_gales
gazania	17	4	612	3	gazania
goaled	8	50	1436	3	goaled
halala	9	47	1509	3	halal_a
hale	7	60	5283	3	_hale_
haled	9	53	3582	3	_haled
haler	8	50	3352	3	_haler
hales	8	54	4984	3	_hales
halma	10	82	1925	3	_halma
halva	11	54	1443	3	_halva
hawala	12	36	891	3	hawal_a
healed	10	51	2144	3	healed
healer	9	42	2180	3	healer
ilea	4	59	3146	3	__ilea
jacales	16	3	1032	3	jacales
kabala	12	40	1155	3	kabal_a
kale	8	65	3375	3	_kale_
kales	9	57	3098	3	_kales
kalpa	11	45	1219	3	_kalpa
kamala	12	33	996	3	kamal_a
koala	9	51	1221	3	koal_a
lazaret	16	4	1178	3	lazaret
lea	3	76	6018	3	___lea
male	6	60	5230	3	_male_
males	7	50	4979	3	_males
masala	8	3	1181	3	masal_a
nala	4	69	3039	3	_nal_a
naled	6	55	2505	3	_naled
nyala	8	3	682	3	nyal_a
olea	4	65	3272	3	__olea
ozalid	16	9	668	3	ozalid
pale	6	60	5501	3	_pale_
paleae	8	48	2029	3	_paleae
paleal	8	47	1667	3	_paleal
paled	8	55	3872	3	_paled
paler	7	54	3693	3	_paler
pales	7	57	5380	3	_pales
palet	7	46	5080	3	_palet
panacea	11	3	778	3	panacea
pealed	9	53	2280	3	pealed
pilea	7	51	2395	3	_pilea
plea	6	68	3060	3	__plea
qabala	17	39	919	3	qabal_a
quale	14	36	1785	3	quale_
qualia	15	5	956	3	qualia
quelea	15	4	730	3	quelea
rale	4	50	5056	3	_rale_
rales	5	49	4749	3	_rales
realer	6	35	2859	3	realer
reales	6	49	3412	3	reales
realia	6	3	1459	3	realia
sale	4	49	5970	3	_sale_
salep	7	70	2295	3	_salep
sales	5	60	5559	3	_sales
salpa	7	50	1835	3	_salpa
salsa	5	67	1892	3	_salsa
scale	7	46	2914	3	scale_
scaled	9	48	2244	3	scaled
scaler	8	43	2160	3	scaler
scales	8	45	2931	3	scales
sealed	7	43	2836	3	sealed
sealer	6	39	2896	3	sealer
shale	8	53	3283	3	shale_
shaled	10	50	2395	3	shaled
shales	9	47	3125	3	shales
shaley	12	37	1499	3	shaley
spale	7	49	2921	3	spale_
spales	8	47	2810	3	spales
stale	5	56	3710	3	stale_
staled	7	47	2810	3	staled
staler	6	40	2582	3	staler
stales	6	55	3829	3	stales
swale	8	52	2159	3	swale_
swales	9	39	2076	3	swales
tala	4	59	3805	3	_tal_a
tale	4	61	5416	3	_tale_
taler	5	60	3486	3	_taler
tales	5	54	5137	3	_tales
tamale	8	37	1740	3	tamale_
tamales	9	32	1615	3	tamales
thaler	9	46	1310	3	thaler
vale	7	49	3734	3	_vale_
vales	8	54	3426	3	_vales
valet	8	43	3787	3	_valet
vealed	10	39	1632	3	vealed
vealer	9	40	1654	3	vealer
vialed	10	51	1259	3	vialed
wale	7	45	4643	3	_wale_
waled	9	43	3099	3	_waled
waler	8	42	2926	3	_waler
wales	8	61	4283	3	_wales
walla	8	53	2103	3	_walla
whale	11	55	1743	3	whale_
whaled	13	46	1203	3	whaled
whaler	12	46	1197	3	whaler
whales	12	47	1694	3	whales
yamalka	16	5	296	3	yamalka
zamia	16	51	1521	3	_zamia
zanza	13	7	870	3	_zanza
zareba	17	3	642	3	_zareba
zaxes	21	51	1382	3	_zaxes
zazen	13	3	728	3	_zazen
zoea	13	71	1842	3	_z_oea

Search took 7 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.156	1145455.1
2	DLD Change Limit	112716	307	5.893	19127.1
3	Display Results	307	307	0.110	2790.9
	(SQL Overall)	178691	307	6.159	29013.0