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

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

69 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
wheals	12	45	1252	(None)
heals	8	57	3346	1	_heals
sheals	9	44	2064	1	sheals
weals	8	54	2874	1	w_eals
wheal	11	57	1618	1	wheal_
wheats	12	50	1322	1	wheats
wheels	12	38	1172	1	wheels
cheaps	13	46	1368	2	cheaps
cheats	11	45	1954	2	cheats
chelas	11	38	1720	2	chelas
deals	6	54	3534	2	_deals
dhals	9	54	1544	2	dh_als
heads	9	51	2711	2	_heads
heal	7	56	4569	2	_heal_
heaps	10	52	2322	2	_heaps
hears	8	67	3737	2	_hears
heats	8	58	3840	2	_heats
heels	8	56	2553	2	_heels
heils	8	52	2219	2	_heils
hells	8	50	3204	2	_hells
herls	8	52	2643	2	_herls
ideals	7	50	1250	2	ideals
meals	7	59	3338	2	_meals
peals	7	52	3549	2	_peals
phials	11	5	887	2	phials
reals	5	50	3865	2	_reals
rheas	8	48	1695	2	rhea_s
seals	5	48	3970	2	_seals
sheafs	12	49	1288	2	sheafs
sheal	8	49	2770	2	sheal_
shears	9	38	2090	2	shears
sheas	8	63	3179	2	shea_s
shells	9	43	1952	2	shells
sheols	9	46	1416	2	sheols
shoals	9	42	1579	2	shoals
steals	6	40	2006	2	steals
teals	5	62	3413	2	_teals
veals	8	49	2619	2	_veals
weal	7	58	3868	2	w_eal_
weald	9	56	1502	2	w_eald
wealds	10	45	910	2	w_ealds
weans	8	53	2674	2	w_eans
wears	8	60	3030	2	w_ears
wells	8	54	2619	2	w_ells
whale	11	55	1743	2	wh_ale
whales	12	47	1694	2	wh_ales
whams	13	55	1564	2	wh_ams
whaps	13	51	1516	2	wh_aps
whats	11	77	1899	2	wh_ats
wheat	11	49	2457	2	whea_t
wheel	11	55	1534	2	wheel_
wheens	12	46	1061	2	wheens
wheeps	14	43	995	2	wheeps
whelk	15	43	1106	2	whe_lk
whelks	16	36	732	2	whelks
whelm	13	46	1198	2	whe_lm
whelms	14	37	757	2	whelms
whelp	13	60	1209	2	whe_lp
whelps	14	43	784	2	whelps
whenas	12	46	1046	2	whenas
whens	11	46	1876	2	whe_ns
wheres	12	59	1744	2	wheres
whets	11	50	1961	2	whe_ts
whews	14	51	1449	2	whe_ws
wheys	14	59	1155	2	whe_ys
whirls	12	47	1053	2	whirls
whorls	12	44	1016	2	whorls
wreaks	13	47	1111	2	wreaks
zeals	14	53	2085	2	_zeals

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	82551	0.356	501941.0
2	DLD Change Limit	82551	69	2.393	34496.9
3	Display Results	69	69	0.013	5307.7
	(SQL Overall)	178691	69	2.762	64696.2