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

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

63 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
miffed	15	39	871	(None)
biffed	15	44	988	1	biffed
misfed	12	41	1302	1	misfed
muffed	15	42	1059	1	muffed
riffed	13	38	1156	1	riffed
tiffed	13	36	839	1	tiffed
baffed	15	48	1217	2	baffed
boffed	15	36	948	2	boffed
buffed	15	43	1314	2	buffed
coiffed	16	3	541	2	coiffed
cuffed	15	43	1121	2	cuffed
daffed	14	42	949	2	daffed
differ	13	39	1084	2	differ
doffed	14	42	850	2	doffed
fifed	12	51	1597	2	fi_fed
gaffed	14	42	1020	2	gaffed
gifted	11	45	1070	2	gifted
huffed	16	37	1015	2	huffed
lifted	10	44	1352	2	lifted
luffed	13	38	1082	2	luffed
malfed	12	36	976	2	malfed
miched	14	39	1339	2	miched
miff	12	56	2507	2	miff__
miffier	15	3	702	2	miffier
miffs	13	45	1288	2	miff_s
miffy	16	39	1020	2	miff_y
miked	12	50	2045	2	mi_ked
milded	10	44	1615	2	milded
milked	13	46	1257	2	milked
milled	9	43	2617	2	milled
milted	9	39	1994	2	milted
mimed	10	56	2273	2	mi_med
minced	11	41	1491	2	minced
minded	10	38	1783	2	minded
mined	8	53	3335	2	mi_ned
minted	9	42	2058	2	minted
mired	8	57	2922	2	mi_red
misfeed	13	38	968	2	misfeed
misled	9	47	1931	2	misled
missed	9	44	2360	2	missed
misted	9	36	2582	2	misted
mitred	9	44	1434	2	mitred
mixed	15	57	1725	2	mi_xed
muffled	16	37	778	2	muffled
naffed	13	40	833	2	naffed
niffer	12	37	844	2	niffer
offed	12	35	916	2	_offed
piaffed	16	9	375	2	piaffed
piffled	16	36	640	2	piffled
puffed	15	35	1060	2	puffed
reffed	13	47	1251	2	reffed
riffled	14	33	860	2	riffled
rifled	10	41	1500	2	rifled
rifted	10	41	1531	2	rifted
ruffed	13	43	1274	2	ruffed
sifted	10	43	1367	2	sifted
sniffed	14	31	818	2	sniffed
spiffed	16	25	710	2	spiffed
stiffed	14	35	958	2	stiffed
waffed	16	45	979	2	waffed
whiffed	20	6	447	2	whiffed
wifed	12	51	1774	2	wi_fed
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	1.063	168100.7
2	DLD Change Limit	82551	63	2.860	28864.0
3	Display Results	63	63	0.016	3937.5
	(SQL Overall)	178691	63	3.939	45364.6