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

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

97 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
buffed	15	43	1314	(None)
baffed	15	48	1217	1	baffed
biffed	15	44	988	1	biffed
bluffed	16	32	643	1	bluffed
boffed	15	36	948	1	boffed
buffer	14	45	1268	1	buffer
buffet	14	31	1378	1	buffet
cuffed	15	43	1121	1	cuffed
huffed	16	37	1015	1	huffed
luffed	13	38	1082	1	luffed
muffed	15	42	1059	1	muffed
puffed	15	35	1060	1	puffed
ruffed	13	43	1274	1	ruffed
baffled	16	41	806	2	baffled
barfed	12	54	1638	2	barfed
beefed	12	35	1087	2	beefed
bluffer	15	39	688	2	bluffer
bouffe	14	43	831	2	bouffe_
bouffes	15	38	863	2	bouffes
buboed	11	30	1000	2	buboed
bucked	15	51	2106	2	bucked
budded	11	39	1233	2	budded
budged	11	45	1723	2	budged
buff	12	52	2986	2	buff__
buffered	17	6	499	2	buffered
buffers	15	33	1079	2	buffers
buffest	15	29	863	2	buffest
buffeted	17	5	373	2	buffeted
buffets	15	31	759	2	buffets
buffi	13	61	1220	2	buff_i
buffier	15	6	840	2	buffier
buffo	13	51	1218	2	buff_o
buffos	14	44	785	2	buffos
buffs	13	55	1951	2	buff_s
buffy	16	50	1337	2	buff_y
bugged	11	43	1840	2	bugged
bugled	10	49	1813	2	bugled
bulbed	11	43	1277	2	bulbed
bulged	10	51	1712	2	bulged
bulked	13	42	1674	2	bulked
bulled	9	46	2649	2	bulled
bummed	13	42	1172	2	bummed
bumped	13	44	1400	2	bumped
bunged	10	52	1879	2	bunged
bunked	13	51	1837	2	bunked
bunted	9	52	1918	2	bunted
buoyed	12	3	669	2	buoyed
buried	9	48	2237	2	buried
burked	13	52	2088	2	burked
burled	9	48	2538	2	burled
burned	9	58	1896	2	burned
burped	11	62	1550	2	burped
burred	9	58	2072	2	burred
bused	8	56	2449	2	bu_sed
bushed	12	48	2238	2	bushed
busied	9	51	1722	2	busied
busked	13	49	1770	2	busked
bussed	9	47	1705	2	bussed
busted	9	51	2315	2	busted
butled	9	48	1860	2	butled
butted	9	47	2206	2	butted
buzzed	17	40	847	2	buzzed
chuffed	19	31	664	2	chuffed
daffed	14	42	949	2	daffed
doffed	14	42	850	2	doffed
duffel	13	40	775	2	duffel
duffer	13	47	1166	2	duffer
fluffed	13	29	590	2	fluffed
gaffed	14	42	1020	2	gaffed
gruffed	15	4	494	2	gruffed
gulfed	11	48	1001	2	gulfed
miffed	15	39	871	2	miffed
muffled	16	37	778	2	muffled
naffed	13	40	833	2	naffed
offed	12	35	916	2	_offed
pouffed	16	36	595	2	pouffed
puffer	14	46	1073	2	puffer
quaffed	23	3	425	2	quaffed
rebuffed	17	4	308	2	rebuffed
reffed	13	47	1251	2	reffed
riffed	13	38	1156	2	riffed
ruffe	11	47	1381	2	ruffe_
ruffes	12	41	1242	2	ruffes
ruffled	14	36	915	2	ruffled
scuffed	16	29	824	2	scuffed
sluffed	14	30	830	2	sluffed
snuffed	14	30	806	2	snuffed
stuffed	14	32	897	2	stuffed
suffer	12	43	1451	2	suffer
surfed	10	38	1446	2	surfed
tiffed	13	36	839	2	tiffed
tuffet	12	26	1208	2	tuffet
tufted	10	35	928	2	tufted
turfed	10	31	1096	2	turfed
unfed	9	46	1422	2	_unfed
waffed	16	45	979	2	waffed
yaffed	16	45	732	2	yaffed

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	82551	0.110	1624463.6
2	DLD Change Limit	82551	97	2.873	28733.4
3	Display Results	97	97	0.033	2939.4
	(SQL Overall)	178691	97	3.016	59247.7