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

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

88 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
whups	13	42	1000	(None)
whaps	13	51	1516	1	whaps
whaups	14	40	575	1	whaups
whips	13	49	1708	1	whips
whops	13	50	1393	1	whops
whumps	16	42	709	1	whumps
whup	12	57	1416	1	whup_
bhuts	10	58	1295	2	bhuts
chaps	12	53	2606	2	chaps
chips	12	57	2125	2	chips
chops	12	50	1987	2	chops
chubs	12	54	1262	2	chubs
chugs	11	55	1194	2	chugs
chumps	15	43	1382	2	chumps
chums	12	50	1583	2	chums
coups	9	55	2247	2	coups
cups	8	54	3082	2	_cups
dups	7	59	2951	2	_dups
haps	9	64	4346	2	_haps
hips	9	64	3370	2	_hips
hops	9	79	4263	2	_hops
hubs	9	60	2714	2	_hubs
hues	7	52	3523	2	_hues
hugs	8	61	2975	2	_hugs
humps	12	63	2280	2	_humps
hums	9	68	3142	2	_hums
huns	7	61	3693	2	_huns
hup	8	64	3781	2	_hup_
huts	7	67	3744	2	_huts
hyps	12	54	1841	2	_hyps
jaups	14	48	1053	2	jaups
loups	7	53	1962	2	loups
phuts	10	46	1350	2	phuts
pups	8	60	3223	2	_pups
rhus	7	51	1405	2	rhu_s
roups	7	51	1890	2	roups
scups	9	53	1665	2	scups
ships	10	51	2377	2	ships
shops	10	42	2290	2	shops
shuls	8	53	1971	2	shuls
shuns	8	50	1814	2	shuns
shuts	8	56	2248	2	shuts
soups	7	53	2294	2	soups
sups	6	48	3443	2	_sups
thuds	9	51	1013	2	thuds
thugs	9	56	1199	2	thugs
thumps	13	44	935	2	thumps
thus	7	67	2147	2	thu_s
tups	6	56	2876	2	_tups
ups	5	56	2905	2	__ups
waps	9	66	4208	2	w_aps
warps	10	71	2642	2	warps
washups	15	3	468	2	washups
wasps	10	67	1469	2	wasps
wauks	12	55	1516	2	wauks
wauls	8	61	2055	2	wauls
weeps	10	41	2056	2	weeps
whams	13	55	1564	2	whams
whap	12	51	1964	2	whap_
whats	11	77	1899	2	whats
whaup	13	45	888	2	whaup_
wheeps	14	43	995	2	wheeps
whelps	14	43	784	2	whelps
whens	11	46	1876	2	whens
whets	11	50	1961	2	whets
whews	14	51	1449	2	whews
wheys	14	59	1155	2	wheys
whids	12	54	1398	2	whids
whigs	12	56	1264	2	whigs
whims	13	45	1533	2	whims
whins	11	49	2233	2	whins
whip	12	55	2184	2	whip_
whipt	13	53	1742	2	whipt
whirs	11	52	1809	2	whirs
whits	11	59	2382	2	whits
whomps	16	45	760	2	whomps
whoops	14	48	786	2	whoops
whop	12	55	2092	2	whop_
whump	15	49	1004	2	whump
whys	13	70	1166	2	wh_ys
wimps	12	52	1380	2	wimps
wisps	10	52	1418	2	wisps
woops	10	49	1752	2	woops
wops	9	66	3415	2	w_ops
wraps	10	56	1715	2	wraps
wuss	7	52	1933	2	w_uss
yaups	10	59	1074	2	yaups
yups	9	61	2160	2	_yups

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.326	548131.9
2	DLD Change Limit	53800	88	1.516	35488.1
3	Display Results	88	88	0.016	5500.0
	(SQL Overall)	178691	88	1.858	96173.8