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

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

99 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
wheys	14	59	1155	(None)
whens	11	46	1876	1	whens
whets	11	50	1961	1	whets
whews	14	51	1449	1	whews
whey	13	50	1871	1	whey_
whys	13	70	1166	1	wh_ys
beys	9	138	2955	2	_beys
chays	13	53	1974	2	chays
chefs	13	62	1466	2	chefs
chess	10	50	1692	2	chess
chews	13	54	1851	2	chews
deys	8	50	2747	2	_deys
fleys	11	70	1560	2	fleys
ghees	9	52	1555	2	ghees
gleys	9	65	1485	2	gleys
greys	9	66	1485	2	greys
hays	10	61	3807	2	_hays
hehs	10	67	2396	2	_hehs
hems	9	55	3494	2	_hems
hens	7	56	4257	2	_hens
hers	7	58	4487	2	_hers
hes	6	66	5420	2	_he_s
hets	7	55	4720	2	_hets
hews	10	56	3157	2	_hews
hey	9	67	4106	2	_hey_
hoys	10	77	3393	2	_hoys
joeys	15	51	804	2	joeys
keys	11	63	2216	2	_keys
khets	12	49	1343	2	khets
leys	7	64	3018	2	_leys
obeys	10	70	1064	2	obeys
preys	10	57	1778	2	preys
queys	17	39	836	2	queys
rheas	8	48	1695	2	rheas
shays	11	60	2143	2	shays
sheas	8	63	3179	2	sheas
sheds	9	61	2270	2	sheds
shes	7	57	3435	2	she_s
shews	11	59	2471	2	shews
thens	8	59	2183	2	thens
thews	11	74	1619	2	thews
they	10	72	2375	2	they_
treys	8	50	1821	2	treys
waes	7	60	4860	2	wae_s
waveys	15	59	701	2	waveys
ways	10	77	3795	2	w_ays
webs	9	66	2212	2	w_ebs
weds	8	66	2893	2	w_eds
weeds	9	52	2221	2	weeds
weeks	12	50	1786	2	weeks
weens	8	52	2405	2	weens
weeps	10	41	2056	2	weeps
wees	7	62	4912	2	w_ees
weets	8	54	2772	2	weets
wens	7	63	3793	2	w_ens
wets	7	59	4029	2	w_ets
whams	13	55	1564	2	whams
whaps	13	51	1516	2	whaps
whats	11	77	1899	2	whats
wheal	11	57	1618	2	wheal
wheals	12	45	1252	2	wheals
wheat	11	49	2457	2	wheat
wheats	12	50	1322	2	wheats
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
wheens	12	46	1061	2	wheens
wheep	13	62	1435	2	wheep
wheeps	14	43	995	2	wheeps
whelk	15	43	1106	2	whelk
whelks	16	36	732	2	whelks
whelm	13	46	1198	2	whelm
whelms	14	37	757	2	whelms
whelp	13	60	1209	2	whelp
whelps	14	43	784	2	whelps
when	10	57	2304	2	whe_n
whenas	12	46	1046	2	whenas
where	11	70	1942	2	where
wheres	12	59	1743	2	wheres
whet	10	51	3378	2	whe_t
whew	13	76	1878	2	whe_w
wheyey	18	3	432	2	wheyey
wheyish	19	4	406	2	wheyish
whids	12	54	1398	2	whids
whigs	12	56	1264	2	whigs
whims	13	45	1533	2	whims
whins	11	49	2233	2	whins
whips	13	49	1708	2	whips
whirs	11	52	1809	2	whirs
whiteys	16	39	615	2	whiteys
whits	11	59	2382	2	whits
whops	13	50	1393	2	whops
whups	13	42	1000	2	whups
why	12	69	2001	2	wh_y_
wifeys	15	42	587	2	wifeys
woes	7	64	4066	2	woe_s
wrens	8	50	1624	2	wrens
wyes	10	57	2750	2	wye_s

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	99	1.546	34799.5
3	Display Results	99	99	0.033	3000.0
	(SQL Overall)	178691	99	1.892	94445.6