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

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

57 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
whelm	13	46	1198	(None)
helm	9	55	3002	1	_helm
whelk	15	43	1106	1	whelk
whelms	14	37	757	1	whelms
whelp	13	60	1209	1	whelp
ahem	9	72	2536	2	ahe_m
chela	10	39	1680	2	chela
elm	5	75	3174	2	__elm
halm	9	58	3497	2	_halm
held	8	53	3040	2	_held
hell	7	56	3789	2	_hell
helms	10	56	1946	2	_helms
helo	7	53	3285	2	_helo
help	9	53	2892	2	_help
hem	8	61	4873	2	_he_m
herm	9	56	3615	2	_herm
holm	9	56	2811	2	_holm
rheum	10	3	884	2	rheum
shelf	11	52	2111	2	shelf
shell	8	44	2412	2	shell
skelm	11	42	1129	2	skelm
them	9	74	2704	2	the_m
therm	10	60	1802	2	therm
unhelm	11	3	686	2	unhelm
weel	7	58	3408	2	weel_
weld	8	47	2773	2	w_eld
well	7	58	3204	2	w_ell
welt	7	55	4786	2	w_elt
whale	11	55	1743	2	whale
wham	12	53	2169	2	wh_am
wheal	11	57	1618	2	wheal
wheals	12	45	1252	2	wheals
wheat	11	49	2457	2	wheat
whee	10	54	2959	2	whe_e
wheel	11	55	1533	2	wheel
wheels	12	38	1171	2	wheels
wheen	11	50	1605	2	wheen
wheep	13	62	1435	2	wheep
whelks	16	36	732	2	whelks
whelky	19	31	497	2	whelky
whelmed	16	37	515	2	whelmed
whelps	14	43	784	2	whelps
when	10	57	2304	2	whe_n
whens	11	46	1876	2	whens
where	11	70	1942	2	where
whet	10	51	3378	2	whe_t
whets	11	50	1961	2	whets
whew	13	76	1878	2	whe_w
whews	14	51	1449	2	whews
whey	13	50	1871	2	whe_y
wheys	14	59	1155	2	wheys
while	11	54	1869	2	while
whilom	14	3	613	2	whilom
whim	12	62	2053	2	wh_im
whole	11	44	1809	2	whole
whom	12	70	1818	2	wh_om
wield	9	52	1391	2	wield

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	57	1.373	39184.3
3	Display Results	57	57	0.016	3562.5
	(SQL Overall)	178691	57	1.702	104988.8