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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

85 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
wheen	11	50	1605	(None)
sheen	8	50	2331	1	sheen
ween	7	58	3546	1	w_een
whee	10	54	2959	1	whee_
wheel	11	55	1533	1	wheel
wheens	12	46	1061	1	wheens
wheep	13	62	1435	1	wheep
when	10	57	2304	1	wh_en
been	6	53	3578	2	_been
cheek	14	51	1571	2	cheek
cheep	12	54	1650	2	cheep
cheer	10	54	2038	2	cheer
ghee	8	57	2611	2	ghee_
ghees	9	52	1555	2	ghees
green	6	55	2214	2	green
haen	7	62	2945	2	_haen
heed	8	64	3760	2	_heed
heel	7	50	3422	2	_heel
hen	6	75	5527	2	_h_en
hern	7	61	3489	2	_hern
hewn	10	67	1985	2	_hewn
keen	8	48	3041	2	_keen
peen	6	59	3808	2	_peen
preen	7	59	2505	2	preen
queen	14	43	1206	2	queen
seen	4	69	4312	2	_seen
sheens	9	51	1699	2	sheens
sheeny	12	49	1219	2	sheeny
sheep	10	53	2152	2	sheep
sheer	8	47	2689	2	sheer
sheet	8	48	3696	2	sheet
shewn	11	57	1570	2	shewn
skeen	9	48	1740	2	skeen
teen	4	59	3820	2	_teen
thee	7	80	3906	2	thee_
thegn	9	58	1090	2	thegn
thein	8	59	1902	2	thein
then	7	84	2969	2	th_en
treen	5	56	2275	2	treen
tween	8	44	1374	2	tween
waken	12	48	1847	2	waken
waxen	15	49	1181	2	waxen
wean	7	57	3435	2	w_ean
wee	6	67	6081	2	w_ee_
weed	8	56	3751	2	w_eed
week	11	64	2815	2	w_eek
weel	7	58	3408	2	w_eel
weens	8	52	2405	2	w_eens
weeny	11	53	1616	2	w_eeny
weep	9	51	3165	2	w_eep
weer	7	55	3509	2	w_eer
wees	7	62	4912	2	w_ees
weet	7	52	5415	2	w_eet
wen	6	62	4960	2	w__en
wheal	11	57	1618	2	wheal
wheat	11	49	2457	2	wheat
wheaten	13	3	640	2	wheaten
wheels	12	38	1171	2	wheels
wheeps	14	43	995	2	wheeps
wheeze	21	27	681	2	wheeze
wheezy	24	24	452	2	wheezy
whelk	15	43	1106	2	whelk
whelm	13	46	1198	2	whelm
whelp	13	60	1209	2	whelp
whens	11	46	1876	2	whens
where	11	70	1942	2	where
wherein	13	21	659	2	wherein
whereon	13	19	650	2	whereon
wheres	12	59	1743	2	wheres
whet	10	51	3378	2	wh_et
whets	11	50	1961	2	whets
whew	13	76	1878	2	wh_ew
whews	14	51	1449	2	whews
whey	13	50	1871	2	wh_ey
wheyey	18	3	432	2	wheyey
wheys	14	59	1155	2	wheys
whin	10	52	2569	2	wh_in
whine	11	60	2281	2	whine
whiten	12	41	1192	2	whiten
widen	9	47	1797	2	widen
wizen	17	58	1386	2	wizen
woken	12	46	1497	2	woken
women	10	46	1925	2	women
woven	11	52	1517	2	woven
wren	7	82	2168	2	w_ren

Search took 2 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	85	1.390	38705.0
3	Display Results	85	85	0.030	2833.3
	(SQL Overall)	178691	85	1.733	103110.8