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

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

82 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
wheep	13	62	1435	(None)
cheep	12	54	1650	1	cheep
sheep	10	53	2152	1	sheep
weep	9	51	3165	1	w_eep
whee	10	54	2959	1	whee_
wheel	11	55	1533	1	wheel
wheen	11	50	1605	1	wheen
wheeps	14	43	995	1	wheeps
whelp	13	60	1209	1	whelp
beep	8	59	3121	2	_beep
bleep	9	50	1345	2	bleep
cheap	12	69	1594	2	cheap
cheek	14	51	1571	2	cheek
cheeps	13	53	1291	2	cheeps
cheer	10	54	2038	2	cheer
creep	9	52	1810	2	creep
deep	7	60	3188	2	_deep
ghee	8	57	2611	2	ghee_
ghees	9	52	1555	2	ghees
heap	9	64	3289	2	_heap
heed	8	64	3760	2	_heed
heel	7	50	3422	2	_heel
help	9	53	2892	2	_help
hemp	11	57	2562	2	_hemp
hep	8	66	4414	2	_h_ep
jeep	13	56	2484	2	_jeep
keep	10	63	2982	2	_keep
kreep	11	46	1041	2	kreep
neep	6	57	2831	2	_neep
peep	8	58	3369	2	_peep
seep	6	65	4034	2	_seep
sheen	8	50	2331	2	sheen
sheer	8	47	2689	2	sheer
sheet	8	48	3696	2	sheet
shlep	10	49	1483	2	shlep
sleep	7	49	2018	2	sleep
steep	7	60	2070	2	steep
sweep	10	47	1572	2	sweep
thee	7	80	3906	2	thee_
thesp	10	54	1031	2	thesp
threep	11	59	1011	2	threep
veep	9	53	2509	2	_veep
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
ween	7	58	3546	2	w_een
weeps	10	41	2056	2	w_eeps
weepy	13	42	1259	2	w_eepy
weer	7	55	3509	2	w_eer
wees	7	62	4912	2	w_ees
weet	7	52	5415	2	w_eet
whap	12	51	1964	2	wh_ap
whaup	13	45	888	2	whaup
wheal	11	57	1618	2	wheal
wheat	11	49	2457	2	wheat
wheels	12	38	1171	2	wheels
wheens	12	46	1061	2	wheens
wheeped	16	38	750	2	wheeped
wheeple	15	3	485	2	wheeple
wheeze	21	27	681	2	wheeze
wheezy	24	24	452	2	wheezy
whelk	15	43	1106	2	whelk
whelm	13	46	1198	2	whelm
whelps	14	43	784	2	whelps
when	10	57	2304	2	wh_en
whens	11	46	1876	2	whens
where	11	70	1942	2	where
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
whip	12	55	2184	2	wh_ip
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

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	82	1.576	34137.1
3	Display Results	82	82	0.016	5125.0
	(SQL Overall)	178691	82	1.905	93801.0