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

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

52 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
gruffs	13	33	745	(None)
griffs	13	39	899	1	griffs
gruff	12	47	1214	1	gruff_
gruffy	16	39	601	1	gruffy
guffs	12	44	1482	1	g_uffs
ruffs	11	45	1674	1	_ruffs
bluffs	14	38	837	2	bluffs
buffs	13	55	1951	2	_buffs
chuffs	17	42	778	2	chuffs
cuffs	13	50	1749	2	_cuffs
draffs	13	61	790	2	draffs
duffs	12	52	1662	2	_duffs
fluffs	11	34	778	2	fluffs
gaffs	12	49	1465	2	g_affs
gliffs	13	43	632	2	gliffs
grafts	10	50	1325	2	grafts
griefs	10	41	872	2	griefs
griff	12	44	1646	2	griff_
griffe	13	43	809	2	griffe
griffes	14	36	792	2	griffes
grifts	10	45	1168	2	grifts
grubs	8	63	1260	2	gru_bs
gruels	7	39	1015	2	gruels
grues	6	57	2196	2	gru_es
gruffed	15	4	494	2	gruffed
gruffer	14	7	579	2	gruffer
gruffest	15	4	459	2	gruffest
gruffish	18	4	394	2	gruffish
gruffly	17	41	389	2	gruffly
grumes	9	44	1555	2	grumes
grumps	11	45	1057	2	grumps
grunts	7	55	1185	2	grunts
guff	11	46	2493	2	g_uff_
gulfs	9	49	1530	2	g_ulfs
huffs	14	45	1474	2	_huffs
luffs	11	45	1628	2	_luffs
muffs	13	41	1421	2	_muffs
pouffs	14	41	812	2	pouffs
puffs	13	41	1493	2	_puffs
raffs	11	50	1752	2	_raffs
riffs	11	51	1461	2	_riffs
ruff	10	51	2765	2	_ruff_
ruffe	11	47	1381	2	_ruffe
ruffes	12	41	1242	2	_ruffes
scruffs	15	5	417	2	scruffs
scuffs	14	41	905	2	scuffs
sluffs	12	34	958	2	sluffs
snuffs	12	35	853	2	snuffs
stuffs	12	38	1022	2	stuffs
truffe	12	7	623	2	truffe
truffes	13	5	677	2	truffes
tuffs	11	51	1826	2	_tuffs

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.360	496363.9
2	DLD Change Limit	82551	52	2.233	36968.7
3	Display Results	52	52	0.016	3250.0
	(SQL Overall)	178691	52	2.609	68490.2