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

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

64 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
whelp	13	60	1209	(None)
help	9	53	2892	1	_help
wheep	13	62	1435	1	wheep
whelk	15	43	1106	1	whelk
whelm	13	46	1198	1	whelm
whelps	14	43	784	1	whelps
cheap	12	69	1594	2	cheap
cheep	12	54	1650	2	cheep
chela	10	39	1680	2	chela
heap	9	64	3289	2	_heap
held	8	53	3040	2	_held
hell	7	56	3789	2	_hell
helm	9	55	3002	2	_helm
helo	7	53	3285	2	_helo
helps	10	52	1934	2	_helps
hemp	11	57	2562	2	_hemp
hep	8	66	4414	2	_he_p
holp	9	57	2755	2	_holp
kelp	10	53	2280	2	_kelp
sheep	10	53	2152	2	sheep
shelf	11	52	2111	2	shelf
shell	8	44	2412	2	shell
shlep	10	49	1483	2	shlep
skelp	11	42	1142	2	skelp
thesp	10	54	1031	2	thesp
weel	7	58	3408	2	weel_
weep	9	51	3165	2	w_eep
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
whap	12	51	1964	2	wh_ap
whaup	13	45	888	2	whaup
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
wheeps	14	43	995	2	wheeps
whelks	16	36	732	2	whelks
whelky	19	31	497	2	whelky
whelms	14	37	757	2	whelms
whelped	16	35	563	2	whelped
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
whip	12	55	2184	2	wh_ip
whole	11	44	1809	2	whole
whomp	15	50	1132	2	whomp
whoop	13	42	1144	2	whoop
whop	12	55	2092	2	wh_op
whump	15	49	1004	2	whump
whup	12	57	1416	2	wh_up
wield	9	52	1391	2	wield
yelp	9	56	2135	2	_yelp

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.093	1921408.6
2	DLD Change Limit	53800	64	1.656	32487.9
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	1.765	101241.4