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

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

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

110 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
allee	5	49	3212	(None)
aglee	6	57	2849	1	aglee
alee	4	66	5232	1	a_lee
allees	6	45	2148	1	allees
allege	7	43	1465	1	allege
allele	6	45	1456	1	allele
alley	8	57	2167	1	alley
callee	8	43	2729	1	callee
mallee	8	45	2559	1	mallee
abele	7	63	2325	2	abele
able	6	63	4053	2	abl_e
abled	8	69	2683	2	abled
abler	7	56	2431	2	abler
ables	7	59	3554	2	ables
ackee	11	58	2537	2	ackee
agee	5	62	4149	2	a_gee
aglet	6	55	3414	2	aglet
agley	9	69	1733	2	agley
agree	6	52	2603	2	agree
ailed	6	62	4028	2	ailed
ajee	11	59	2823	2	a_jee
akee	8	59	3681	2	a_kee
alae	4	56	4375	2	a_lae
alane	5	61	3561	2	alane
alate	5	53	4033	2	alate
alder	6	54	2191	2	alder
ale	3	65	7234	2	a_l_e
alec	6	64	3006	2	a_lec
alef	7	63	4069	2	a_lef
ales	4	70	6710	2	a_les
algae	6	53	1962	2	algae
alien	5	64	2558	2	alien
alike	9	55	2396	2	alike
aline	5	72	4315	2	aline
alive	8	57	2251	2	alive
alkene	10	41	1400	2	alkene
alkie	9	55	2003	2	alkie
all	3	61	4823	2	all__
allay	8	56	2039	2	allay
alleged	9	38	932	2	alleged
alleger	8	31	963	2	alleger
alleges	8	42	1257	2	alleges
alleles	7	38	1203	2	alleles
alleys	9	51	1330	2	alleys
allied	7	42	1715	2	allied
allies	6	38	2767	2	allies
allod	6	44	1838	2	allod
allot	5	49	3387	2	allot
allow	8	54	2066	2	allow
alloy	8	55	1997	2	alloy
alls	4	67	4092	2	all_s
allseed	8	3	595	2	allseed
allude	7	39	1090	2	allude
allure	6	30	1294	2	allure
ally	7	69	3564	2	all_y
allyl	8	53	1054	2	allyl
alme	6	58	3216	2	a_lme
almeh	10	62	1455	2	almeh
almes	7	51	2654	2	almes
aloe	4	55	4019	2	a_loe
aloes	5	49	3367	2	aloes
alone	5	57	3296	2	alone
alter	5	48	2850	2	alter
alulae	6	3	1274	2	alulae
anele	5	56	2883	2	anele
arles	5	67	3574	2	arles
asleep	8	4	728	2	asleep
awee	7	63	3664	2	a_wee
axle	11	64	2460	2	axl_e
axled	13	53	1581	2	axled
axles	12	52	1947	2	axles
bailee	8	45	2601	2	bailee
balled	9	49	2689	2	balled
baller	8	38	2520	2	baller
ballet	8	47	3397	2	ballet
called	9	41	2673	2	called
callees	9	41	1778	2	callees
caller	8	51	2548	2	caller
callet	8	45	3676	2	callet
dalles	7	42	2206	2	dalles
fallen	9	38	1337	2	fallen
faller	9	46	2123	2	faller
flee	7	62	3879	2	_flee
galilee	8	3	1221	2	galilee
galled	8	46	2286	2	galled
gallet	7	36	3085	2	gallet
galley	10	42	1545	2	galley
gelee	6	36	2698	2	gelee
glee	5	52	3906	2	_glee
hallel	9	35	1409	2	hallel
iller	5	48	2129	2	iller
lalled	7	42	1875	2	lalled
laree	5	60	3629	2	laree
lee	3	60	6814	2	__lee
malled	9	46	2611	2	malled
mallees	9	33	1597	2	mallees
mallei	8	44	1463	2	mallei
mallet	8	44	3305	2	mallet
melee	7	37	2910	2	melee
palled	9	46	2516	2	palled
pallet	8	42	3265	2	pallet
pollee	8	36	2327	2	pollee
rallye	9	51	1016	2	rallye
sallet	6	37	3454	2	sallet
taller	6	37	2196	2	taller
valley	12	43	1160	2	valley
walled	10	40	2129	2	walled
wallet	9	33	2709	2	wallet
walleye	13	3	624	2	walleye
wallie	9	32	1680	2	wallie

Search took 3 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	53800	0.313	570897.8
2	DLD Change Limit	53800	110	1.906	28226.7
3	Display Results	110	110	0.030	3666.7
	(SQL Overall)	178691	110	2.249	79453.5