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

Here are the results of your fuzzy-string dictionary search for “guffs” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

104 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
guffs	12	44	1482	(None)
buffs	13	55	1951	1	buffs
cuffs	13	50	1749	1	cuffs
duffs	12	52	1662	1	duffs
gaffs	12	49	1465	1	gaffs
gruffs	13	33	745	1	gruffs
guff	11	46	2493	1	guff_
gulfs	9	49	1530	1	gulfs
huffs	14	45	1474	1	huffs
luffs	11	45	1628	1	luffs
muffs	13	41	1421	1	muffs
puffs	13	41	1493	1	puffs
ruffs	11	45	1674	1	ruffs
tuffs	11	51	1826	1	tuffs
baffs	13	47	1805	2	baffs
biffs	13	48	1441	2	biffs
bluffs	14	38	837	2	bluffs
boffs	13	49	1550	2	boffs
buff	12	52	2986	2	buff_
buffi	13	61	1220	2	buffi
buffo	13	51	1218	2	buffo
buffos	14	44	785	2	buffos
buffy	16	50	1337	2	buffy
bumfs	12	54	1405	2	bumfs
caffs	13	54	1737	2	caffs
chuffs	17	42	778	2	chuffs
coffs	13	49	1630	2	coffs
cuff	12	53	2799	2	cuff_
cuifs	10	48	1469	2	cuifs
curfs	10	51	2214	2	curfs
daffs	12	51	1642	2	daffs
diffs	12	63	1548	2	diffs
doffs	12	56	1433	2	doffs
duff	11	43	2664	2	duff_
dufus	9	40	1081	2	dufus
effs	10	51	1403	2	_effs
fluffs	11	34	778	2	fluffs
gaff	11	48	2815	2	gaff_
gaffe	12	41	1165	2	gaffe
gaffes	13	48	1110	2	gaffes
gifts	9	62	1496	2	gifts
gliffs	13	43	632	2	gliffs
golfs	9	56	1610	2	golfs
goofs	9	48	2100	2	goofs
griffs	13	39	899	2	griffs
gruff	12	47	1214	2	gruff_
gruffy	16	39	601	2	gruffy
guans	6	44	1944	2	guans
guars	6	50	2105	2	guars
gucks	12	39	1730	2	gucks
gudes	7	45	2081	2	gudes
guess	6	42	1336	2	guess
guffaw	16	4	279	2	guffaw
guffaws	17	6	227	2	guffaws
guids	7	55	1615	2	guids
gules	6	48	3104	2	gules
gulf	8	49	2942	2	gulf_
gulfy	12	46	1200	2	gulfy
gulls	6	52	2298	2	gulls
gulps	8	47	1507	2	gulps
guls	5	59	3085	2	gu_ls
gums	7	50	3094	2	gu_ms
gunks	10	45	1772	2	gunks
guns	5	55	3348	2	gu_ns
gurus	6	43	1819	2	gurus
gusts	6	57	2279	2	gusts
guts	5	66	3725	2	gu_ts
guvs	8	58	1681	2	gu_vs
guys	8	50	1964	2	gu_ys
huff	13	56	2384	2	huff_
huffy	17	48	1023	2	huffy
jiffs	18	57	1031	2	jiffs
kufis	12	4	925	2	kufis
luff	10	44	2670	2	luff_
luffa	11	40	902	2	luffa
luffas	12	33	748	2	luffas
miffs	13	45	1288	2	miffs
muff	12	47	2386	2	muff_
naffs	11	62	1396	2	naffs
offs	10	71	1701	2	_offs
pouffs	14	41	812	2	pouffs
puff	12	55	2543	2	puff_
puffy	16	44	1075	2	puffy
quaffs	21	12	569	2	quaffs
quiffs	21	13	543	2	quiffs
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
scuffs	14	41	905	2	scuffs
sluffs	12	34	958	2	sluffs
snuffs	12	35	853	2	snuffs
stuffs	12	38	1022	2	stuffs
surfs	8	50	2254	2	surfs
teffs	11	51	1173	2	teffs
tiffs	11	44	1488	2	tiffs
toffs	11	60	1672	2	toffs
tufas	8	53	1438	2	tufas
tuff	10	45	2852	2	tuff_
tufts	8	57	1327	2	tufts
turfs	8	46	2044	2	turfs
waffs	14	63	1547	2	waffs
yaffs	14	53	1112	2	yaffs

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.310	576422.6
2	DLD Change Limit	53800	104	1.376	39098.8
3	Display Results	104	104	0.030	3466.7
	(SQL Overall)	178691	104	1.716	104132.3