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

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

45 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
stuffy	15	31	708	(None)
snuffy	15	35	624	1	snuffy
stuff	11	38	1705	1	stuff_
stuffs	12	38	1022	1	stuffs
buffy	16	50	1337	2	_buffy
chuffy	20	44	586	2	chuffy
fluffy	14	31	578	2	fluffy
gruffy	16	39	601	2	gruffy
huffy	17	48	1023	2	_huffy
pouffy	17	39	588	2	pouffy
puffy	16	44	1075	2	_puffy
scruffy	18	4	264	2	scruffy
scuff	13	39	1489	2	scuff_
scuffs	14	41	905	2	scuffs
scurfy	14	33	876	2	scurfy
sluff	11	40	1681	2	sluff_
sluffs	12	34	958	2	sluffs
sniffy	15	33	719	2	sniffy
snuff	11	35	1404	2	snuff_
snuffly	16	30	520	2	snuffly
snuffs	12	35	853	2	snuffs
spiffy	17	32	622	2	spiffy
squiffy	25	4	257	2	squiffy
staff	11	38	1771	2	staff_
staffs	12	34	975	2	staffs
stiff	11	42	1924	2	stiff_
stiffly	16	23	517	2	stiffly
stiffs	12	38	996	2	stiffs
stubby	13	4	504	2	stubby
studly	10	39	769	2	studly
study	9	44	1179	2	stu_dy
stuffed	14	32	897	2	stuffed
stuffer	13	34	979	2	stuffer
stuffily	17	12	416	2	stuffily
stumpy	13	45	813	2	stumpy
stupefy	15	4	290	2	stupefy
sturdy	10	3	704	2	sturdy
surfy	11	53	1947	2	s_urfy
taffy	14	51	1082	2	_taffy
toffy	14	53	1028	2	_toffy
tuff	10	45	2852	2	_tuff_
tuffs	11	51	1826	2	_tuffs
tufty	11	48	1041	2	_tufty
turfy	11	43	1540	2	_turfy
unstuffy	17	6	167	2	unstuffy

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.343	520965.0
2	DLD Change Limit	82551	45	2.360	34979.2
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	2.719	65719.4