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

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

83 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
rolfed	10	45	1052	(None)
golfed	11	56	976	1	golfed
rolfer	9	44	1227	1	rolfer
rolled	7	42	2024	1	rolled
roofed	10	52	1474	1	roofed
wolfed	13	42	801	1	wolfed
boffed	15	36	948	2	boffed
bolled	9	47	2265	2	bolled
bolted	9	46	1780	2	bolted
coifed	12	41	1306	2	coifed
coled	8	55	4076	2	col_ed
doffed	14	42	850	2	doffed
doled	7	54	3091	2	dol_ed
dolled	8	35	1807	2	dolled
drolled	9	38	1022	2	drolled
folded	11	42	1279	2	folded
golfer	10	44	1118	2	golfer
goofed	11	49	1138	2	goofed
gulfed	11	48	1001	2	gulfed
holed	9	56	3413	2	hol_ed
holked	14	49	1366	2	holked
hoofed	13	46	1489	2	hoofed
jolted	14	35	1063	2	jolted
loafed	10	40	1115	2	loafed
lolled	7	43	1582	2	lolled
malfed	12	36	976	2	malfed
molded	10	44	1408	2	molded
molted	9	42	1747	2	molted
offed	12	35	916	2	_offed
poled	8	49	3484	2	pol_ed
polled	9	40	2200	2	polled
poufed	12	44	971	2	poufed
proofed	13	13	872	2	proofed
reefed	10	38	1658	2	reefed
refed	9	39	2192	2	r_efed
reffed	13	47	1251	2	reffed
relied	7	49	2623	2	relied
riffed	13	38	1156	2	riffed
rifled	10	41	1500	2	rifled
riled	6	58	3325	2	ril_ed
rilled	7	45	2565	2	rilled
roamed	9	52	1509	2	roamed
roared	7	50	1539	2	roared
robbed	11	34	1519	2	robbed
robed	8	53	2373	2	ro_bed
rocked	13	50	2232	2	rocked
rodded	9	37	1370	2	rodded
rogued	8	47	1147	2	rogued
roiled	7	43	2005	2	roiled
role	4	58	5182	2	rol_e_
roles	5	67	4798	2	rol_es
rolf	7	51	3487	2	rolf__
rolfers	10	40	1181	2	rolfers
rolfs	8	48	1712	2	rolf_s
roller	6	39	1979	2	roller
romped	11	45	1365	2	romped
roofer	9	44	1528	2	roofer
rooked	11	49	1814	2	rooked
roomed	9	52	1854	2	roomed
roosed	7	56	2160	2	roosed
rooted	7	54	2400	2	rooted
roped	8	46	3081	2	ro_ped
rosed	6	59	3035	2	ro_sed
rotted	7	45	2443	2	rotted
rouged	8	67	1732	2	rouged
rouped	9	57	1735	2	rouped
roused	7	54	2645	2	roused
routed	7	56	2433	2	routed
roved	9	53	2355	2	ro_ved
rowed	9	40	3432	2	ro_wed
ruffed	13	43	1274	2	ruffed
ruled	6	58	2252	2	rul_ed
selfed	10	3	1091	2	selfed
soled	6	58	3517	2	sol_ed
soloed	7	45	1574	2	soloed
solved	10	53	1293	2	solved
toled	6	59	3492	2	tol_ed
tolled	7	38	1903	2	tolled
trolled	8	43	1226	2	trolled
voled	9	53	2372	2	vol_ed
wolfer	12	42	998	2	wolfer
woofed	13	45	1120	2	woofed
yolked	14	36	715	2	yolked

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.343	520965.0
2	DLD Change Limit	82551	83	2.580	31996.5
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	2.953	60511.7