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

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

85 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
baffed	15	48	1217	(None)
baffled	16	41	806	1	baffled
barfed	12	54	1638	1	barfed
biffed	15	44	988	1	biffed
boffed	15	36	948	1	boffed
buffed	15	43	1314	1	buffed
daffed	14	42	949	1	daffed
gaffed	14	42	1020	1	gaffed
naffed	13	40	833	1	naffed
waffed	16	45	979	1	waffed
yaffed	16	45	732	1	yaffed
baaed	8	52	1816	2	ba_aed
babied	11	49	1351	2	babied
bached	14	55	1989	2	bached
backed	15	57	2572	2	backed
badged	11	48	1478	2	badged
baff	12	46	3227	2	baff__
baffies	15	36	1294	2	baffies
baffle	14	39	987	2	baffle
baffler	15	41	811	2	baffler
baffles	15	37	1068	2	baffles
baffs	13	47	1805	2	baff_s
baffy	16	55	1192	2	baff_y
bagged	11	45	1990	2	bagged
bailed	9	47	2665	2	bailed
baited	9	53	1924	2	baited
baked	12	61	3077	2	ba_ked
balded	10	54	1751	2	balded
baled	8	54	3644	2	ba_led
balked	13	52	1941	2	balked
balled	9	49	2689	2	balled
bammed	13	39	1324	2	bammed
banded	10	52	2317	2	banded
baned	8	54	3635	2	ba_ned
banged	10	49	2372	2	banged
banked	13	50	2144	2	banked
banned	9	47	2134	2	banned
barbed	11	51	2131	2	barbed
barded	10	54	2642	2	barded
bared	8	51	4448	2	ba_red
barged	10	58	2264	2	barged
barked	13	50	2731	2	barked
barned	9	56	2358	2	barned
barred	9	57	2579	2	barred
based	8	53	3158	2	ba_sed
bashed	12	62	2570	2	bashed
basked	13	52	1860	2	basked
basted	9	52	2723	2	basted
bated	8	59	3553	2	ba_ted
bathed	12	55	1874	2	bathed
batted	9	56	2365	2	batted
bawled	12	44	1569	2	bawled
bayed	11	54	2302	2	ba_yed
beefed	12	35	1087	2	beefed
bluffed	16	32	643	2	bluffed
buffer	14	45	1268	2	buffer
buffet	14	31	1378	2	buffet
chaffed	19	38	770	2	chaffed
cuffed	15	43	1121	2	cuffed
doffed	14	42	850	2	doffed
gaffe	12	41	1165	2	gaffe_
gaffer	13	43	1013	2	gaffer
gaffes	13	48	1110	2	gaffes
haffet	15	3	1170	2	haffet
hafted	13	47	1383	2	hafted
huffed	16	37	1015	2	huffed
luffed	13	38	1082	2	luffed
malfed	12	36	976	2	malfed
miffed	15	39	871	2	miffed
muffed	15	42	1059	2	muffed
offed	12	35	916	2	_offed
piaffed	16	9	375	2	piaffed
puffed	15	35	1060	2	puffed
quaffed	23	3	425	2	quaffed
raffled	14	42	908	2	raffled
rafted	10	47	1470	2	rafted
reffed	13	47	1251	2	reffed
riffed	13	38	1156	2	riffed
ruffed	13	43	1274	2	ruffed
staffed	14	29	828	2	staffed
tiffed	13	36	839	2	tiffed
waffled	17	35	752	2	waffled
wafted	13	40	1214	2	wafted
waifed	13	40	1103	2	waifed
zaffer	21	39	715	2	zaffer

Search took 3 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.106	1685764.2
2	DLD Change Limit	82551	85	2.580	31996.5
3	Display Results	85	85	0.013	6538.5
	(SQL Overall)	178691	85	2.699	66206.4