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

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

90 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
yolked	14	36	715	(None)
holked	14	49	1366	1	holked
yocked	16	41	1442	1	yocked
yoked	13	48	2162	1	yo_ked
balked	13	52	1941	2	balked
bilked	13	40	1294	2	bilked
bolled	9	47	2265	2	bolled
bolted	9	46	1780	2	bolted
bonked	13	55	1731	2	bonked
booked	13	53	1950	2	booked
borked	13	51	1729	2	borked
bulked	13	42	1674	2	bulked
calked	13	46	1740	2	calked
cocked	15	50	2256	2	cocked
coked	12	47	3069	2	co_ked
coled	8	55	4075	2	col_ed
conked	13	50	1911	2	conked
cooked	13	59	2136	2	cooked
corked	13	50	2078	2	corked
docked	14	50	1833	2	docked
doled	7	54	3091	2	dol_ed
dolled	8	35	1807	2	dolled
folded	11	42	1279	2	folded
forked	14	52	1714	2	forked
golfed	11	56	976	2	golfed
hocked	16	55	2130	2	hocked
hoked	13	53	2699	2	ho_ked
holed	9	56	3413	2	hol_ed
honked	14	45	1791	2	honked
hooked	14	53	2055	2	hooked
howked	17	73	1234	2	howked
hulked	14	46	1130	2	hulked
joked	17	52	1791	2	jo_ked
jolted	14	35	1063	2	jolted
jouked	18	56	815	2	jouked
konked	10	40	1058	2	konked
locked	13	49	2166	2	locked
lolled	7	43	1582	2	lolled
looked	11	47	1707	2	looked
milked	13	46	1257	2	milked
mocked	15	47	1661	2	mocked
molded	10	44	1408	2	molded
molted	9	42	1747	2	molted
nocked	13	46	1738	2	nocked
pocked	15	48	1898	2	pocked
poked	12	54	2539	2	po_ked
poled	8	49	3484	2	pol_ed
polkaed	14	3	532	2	polkaed
polled	9	40	2200	2	polled
porked	13	47	1762	2	porked
rocked	13	50	2232	2	rocked
rolfed	10	45	1052	2	rolfed
rolled	7	42	2024	2	rolled
rooked	11	49	1814	2	rooked
silked	11	43	1481	2	silked
soaked	11	47	1759	2	soaked
socked	13	47	2150	2	socked
soled	6	58	3517	2	sol_ed
soloed	7	45	1574	2	soloed
solved	10	53	1293	2	solved
sulked	11	43	1470	2	sulked
talked	11	40	1540	2	talked
toked	10	56	2649	2	to_ked
toled	6	59	3492	2	tol_ed
tolled	7	38	1903	2	tolled
voled	9	53	2372	2	vol_ed
walked	14	53	1378	2	walked
wolfed	13	42	801	2	wolfed
worked	14	53	1470	2	worked
yacked	16	45	1679	2	yacked
yakked	13	36	609	2	yakked
yanked	14	43	1224	2	yanked
yelled	10	41	1625	2	yelled
yelped	12	43	936	2	yelped
yerked	14	50	937	2	yerked
yeuked	14	45	623	2	yeuked
yodled	11	38	964	2	yodled
yoke	11	56	2639	2	yo_ke_
yokel	12	48	1261	2	yo_kel
yokes	12	52	2302	2	yo_kes
yolk	11	62	1899	2	yolk__
yolkier	14	33	612	2	yolkier
yolks	12	54	1277	2	yolk_s
yolky	15	52	952	2	yolk_y
yonker	13	41	1085	2	yonker
yowed	12	530	2518	2	yo_wed
yowled	13	38	1108	2	yowled
yucked	16	40	1356	2	yucked
yukked	13	31	487	2	yukked
zonked	20	42	947	2	zonked

Search took 7 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.296	603685.8
2	DLD Change Limit	82551	90	5.780	14282.2
3	Display Results	90	90	0.063	1428.6
	(SQL Overall)	178691	90	6.139	29107.5