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

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

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.

64 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
guffaws	17	6	227	(None)
guffaw	16	4	279	1	guffaw_
guffawed	19	4	162	2	guffawed
guffs	12	44	1482	2	guff__s
luffas	12	33	748	2	luffa_s
buffalo	15	5	372	3	buffalo
buffalos	16	4	286	3	buffalos
buffers	15	33	1079	3	buffers
buffets	15	31	759	3	buffets
buffos	14	44	785	3	buff_os
buffs	13	55	1951	3	buff__s
cuffs	13	50	1749	3	cuff__s
curfews	15	29	491	3	curfews
cushaws	15	35	629	3	cushaws
duffels	14	29	645	3	duffels
duffers	14	34	1009	3	duffers
duffles	14	30	892	3	duffles
duffs	12	52	1662	3	duff__s
flaws	11	59	2034	3	__flaws
gaffers	14	42	871	3	gaffers
gaffes	13	48	1110	3	gaff_es
gaffs	12	49	1465	3	gaff__s
gauffers	15	6	383	3	gauffers
geegaws	12	4	234	3	geegaws
gewgaws	15	4	164	3	gewgaws
gnaws	9	63	1114	3	g__naws
goffers	14	40	921	3	goffers
gruffs	13	33	745	3	gruff__s
guaiacs	10	5	435	3	guaiacs
guanays	11	3	495	3	guanays
guans	6	44	1944	3	gu__ans
guars	6	50	2105	3	gu__ars
guavas	10	3	716	3	guava_s
guff	11	46	2493	3	guff___
guffawing	20	4	186	3	guffawing
guitars	8	11	686	3	guitars
gulags	8	3	754	3	gu_lags
gulfs	9	49	1530	3	gulf__s
gummas	11	48	1051	3	gumma_s
huffs	14	45	1474	3	huff__s
luffa	11	40	902	3	luffa__
luffs	11	45	1628	3	luff__s
muffins	15	30	834	3	muffins
muffles	15	39	1045	3	muffles
muffs	13	41	1421	3	muff__s
offals	12	3	589	3	_offals
outfawn	13	3	598	3	outfawn
outfawns	14	3	472	3	outfawns
outlaws	10	24	960	3	outlaws
puffers	15	34	920	3	puffers
puffins	15	27	891	3	puffins
puffs	13	41	1493	3	puff__s
ruffes	12	41	1242	3	ruff_es
ruffians	14	4	379	3	ruffians
ruffles	13	35	1227	3	ruffles
ruffs	11	45	1674	3	ruff__s
suffari	13	4	550	3	suffari
suffaris	14	4	508	3	suffaris
suffers	13	31	1354	3	suffers
sulfas	9	3	1156	3	sulfa_s
tufas	8	53	1438	3	tu_fa_s
tuffets	13	26	652	3	tuffets
tuffs	11	51	1826	3	tuff__s
zaffars	22	32	523	3	zaffars

Search took 7 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	134027	0.390	458182.1
2	DLD Change Limit	134027	64	6.033	22215.6
3	Display Results	64	64	0.013	4923.1
	(SQL Overall)	178691	64	6.436	27764.3