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

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

56 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
puffers	15	34	920	(None)
buffers	15	33	1079	1	buffers
duffers	14	34	1009	1	duffers
puffer	14	46	1073	1	puffer_
puffery	18	23	511	1	puffery
suffers	13	31	1354	1	suffers
bluffers	16	40	570	2	bluffers
buffer	14	45	1268	2	buffer_
buffets	15	31	759	2	buffets
coffers	15	41	1269	2	coffers
differs	14	33	997	2	differs
doffers	14	35	985	2	doffers
duffels	14	29	645	2	duffels
duffer	13	47	1166	2	duffer_
fluffers	13	33	529	2	fluffers
gaffers	14	42	871	2	gaffers
gauffers	15	6	383	2	gauffers
goffers	14	40	921	2	goffers
mufflers	16	31	600	2	mufflers
niffers	13	28	736	2	niffers
offers	12	34	996	2	_offers
piaffers	16	11	420	2	piaffers
pilfers	12	3	896	2	pilfers
pouffes	15	40	812	2	pouffe_s
prefers	12	37	1333	2	prefers
proffers	16	12	659	2	proffers
puckers	15	35	1467	2	puckers
puffed	15	35	1060	2	puffe_d
pufferies	17	4	520	2	pufferies
puffier	15	4	797	2	puffier_
puffins	15	27	891	2	puffins
puffs	13	41	1493	2	puff__s
pulers	8	38	2028	2	pu_lers
pullers	9	36	1848	2	pullers
pulpers	11	46	1228	2	pulpers
pulsers	9	42	1315	2	pulsers
pumpers	13	31	1367	2	pumpers
punkers	13	37	1485	2	punkers
punners	9	41	1423	2	punners
punters	9	36	1703	2	punters
purflers	13	21	696	2	purflers
purgers	10	47	1400	2	purgers
pursers	9	39	1609	2	pursers
pushers	12	38	1450	2	pushers
putters	9	42	1918	2	putters
quaffers	23	3	396	2	quaffers
ruffes	12	41	1242	2	ruffe_s
rufflers	14	34	719	2	rufflers
scuffers	16	30	749	2	scuffers
snuffers	14	32	691	2	snuffers
stuffers	14	27	738	2	stuffers
suffer	12	43	1451	2	suffer_
surfers	10	36	1413	2	surfers
tuffets	13	26	652	2	tuffets
tufters	10	29	834	2	tufters
zaffers	22	38	677	2	zaffers

Search took 4 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	107671	0.123	1452772.4
2	DLD Change Limit	107671	56	3.456	31154.8
3	Display Results	56	56	0.013	4307.7
	(SQL Overall)	178691	56	3.592	49746.9