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

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

87 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
riffed	13	38	1156	(None)
biffed	15	44	988	1	biffed
miffed	15	39	871	1	miffed
reffed	13	47	1251	1	reffed
riffled	14	33	860	1	riffled
rifled	10	41	1500	1	rifled
rifted	10	41	1531	1	rifted
ruffed	13	43	1274	1	ruffed
tiffed	13	36	839	1	tiffed
baffed	15	48	1217	2	baffed
boffed	15	36	948	2	boffed
briefed	13	3	574	2	briefed
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
drifted	12	36	795	2	drifted
fifed	12	51	1597	2	fi_fed
gaffed	14	42	1020	2	gaffed
gifted	11	45	1070	2	gifted
griffe	13	43	809	2	griffe_
griffes	14	36	792	2	griffes
grifted	12	37	958	2	grifted
gruffed	15	4	494	2	gruffed
huffed	16	37	1015	2	huffed
lifted	10	44	1352	2	lifted
luffed	13	38	1082	2	luffed
misfed	12	41	1302	2	misfed
muffed	15	42	1059	2	muffed
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
raffled	14	42	908	2	raffled
rafted	10	47	1470	2	rafted
reefed	10	38	1658	2	reefed
refed	9	39	2192	2	r_efed
refeed	10	47	1762	2	refeed
reified	11	29	1378	2	reified
ribbed	11	40	1437	2	ribbed
riced	8	58	2554	2	ri_ced
ricked	13	65	2362	2	ricked
ridded	9	36	1512	2	ridded
ridged	9	40	1421	2	ridged
rife	7	46	3232	2	ri_fe_
rifer	8	47	2198	2	ri_fer
riff	10	44	3009	2	riff__
riffle	12	42	1023	2	riffle
riffler	13	32	835	2	riffler
riffles	13	39	1116	2	riffles
riffs	11	51	1461	2	riff_s
rifle	8	55	1833	2	rifle_
rifler	9	40	1426	2	rifler
rifles	9	42	1770	2	rifles
rigged	9	45	1740	2	rigged
riled	6	58	3325	2	ri_led
rilled	7	45	2565	2	rilled
rimed	8	48	2637	2	ri_med
rimmed	11	48	1230	2	rimmed
rinded	8	44	1898	2	rinded
ringed	8	46	2384	2	ringed
rinsed	7	50	1635	2	rinsed
rioted	7	34	1637	2	rioted
riped	8	52	2643	2	ri_ped
ripped	11	44	1901	2	ripped
risked	11	55	1463	2	risked
rived	9	48	2561	2	ri_ved
rolfed	10	45	1052	2	rolfed
roofed	10	52	1474	2	roofed
ruffe	11	47	1381	2	ruffe_
ruffes	12	41	1242	2	ruffes
ruffled	14	36	915	2	ruffled
seriffed	15	9	497	2	seriffed
sifted	10	43	1367	2	sifted
sniffed	14	31	818	2	sniffed
spiffed	16	25	710	2	spiffed
stiffed	14	35	958	2	stiffed
tariffed	15	3	372	2	tariffed
trifled	11	37	1196	2	trifled
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 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.126	1418182.5
2	DLD Change Limit	82551	87	2.560	32246.5
3	Display Results	87	87	0.016	5437.5
	(SQL Overall)	178691	87	2.702	66132.9