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

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

50 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
gruff	12	47	1214	(None)
griff	12	44	1646	1	griff
gruffs	13	33	745	1	gruffs
gruffy	16	39	601	1	gruffy
guff	11	46	2493	1	g_uff
ruff	10	51	2765	1	_ruff
bluff	13	44	1383	2	bluff
buff	12	52	2986	2	_buff
chuff	16	48	1249	2	chuff
cuff	12	53	2799	2	_cuff
draff	12	56	1566	2	draff
duff	11	43	2664	2	_duff
fluff	10	39	1361	2	fluff
gaff	11	48	2815	2	g_aff
gliff	12	49	1566	2	gliff
graft	9	53	2720	2	graft
grief	9	53	1978	2	grief
griffe	13	43	809	2	griffe
griffs	13	39	899	2	griffs
grift	9	59	2446	2	grift
grub	7	72	2008	2	gru_b
grubs	8	63	1260	2	grubs
grue	5	58	2571	2	gru_e
gruel	6	60	1474	2	gruel
grues	6	57	2196	2	grues
gruffed	15	4	494	2	gruffed
gruffer	14	7	579	2	gruffer
gruffly	17	41	389	2	gruffly
grum	7	56	2508	2	gru_m
grume	8	62	1816	2	grume
grump	10	51	1531	2	grump
grunt	6	55	2354	2	grunt
guffs	12	44	1482	2	g_uffs
gulf	8	49	2942	2	g_ulf
huff	13	56	2384	2	_huff
luff	10	44	2670	2	_luff
muff	12	47	2386	2	_muff
pouff	13	52	1542	2	pouff
puff	12	55	2543	2	_puff
raff	10	49	3304	2	_raff
riff	10	44	3011	2	_riff
ruffe	11	47	1381	2	_ruffe
ruffs	11	45	1674	2	_ruffs
scruff	14	3	796	2	scruff
scuff	13	39	1489	2	scuff
sluff	11	40	1681	2	sluff
snuff	11	35	1404	2	snuff
stuff	11	38	1705	2	stuff
truffe	12	7	623	2	truffe
tuff	10	45	2852	2	_tuff

Search took 5 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.610	292936.1
2	DLD Change Limit	53800	50	4.266	12611.3
3	Display Results	50	50	0.013	3846.2
	(SQL Overall)	178691	50	4.889	36549.6