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

Here are the results of your fuzzy-string dictionary search for “troked” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

123 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
troked	11	41	1458	(None)
stroked	12	46	1362	1	stroked
toked	10	56	2649	1	t_oked
troaked	12	43	825	1	troaked
trocked	14	43	1224	1	trocked
troke	9	48	2105	1	troke_
trokes	10	40	1926	1	trokes
trowed	10	47	1465	1	trowed
arcked	13	62	1194	2	arcked
booked	13	53	1950	2	booked
borked	13	51	1729	2	borked
braked	13	53	1869	2	braked
broke	11	60	1978	2	broke_
broken	12	40	1152	2	broken
broker	12	43	1424	2	broker
brooked	14	36	1003	2	brooked
browed	12	52	1639	2	browed
choked	16	49	1479	2	choked
coked	12	47	3069	2	_coked
cooked	13	59	2136	2	cooked
corked	13	50	2078	2	corked
croaked	14	37	1053	2	croaked
crocked	16	40	1443	2	crocked
crooked	14	39	1094	2	crooked
crowed	12	47	1730	2	crowed
droned	8	46	1686	2	droned
drouked	13	3	554	2	drouked
droved	11	46	1164	2	droved
eroded	8	43	1358	2	eroded
evoked	14	45	788	2	evoked
forked	14	52	1714	2	forked
frocked	17	43	933	2	frocked
grokked	12	3	367	2	grokked
groped	10	75	1505	2	groped
groved	11	44	1370	2	groved
hoked	13	53	2699	2	_hoked
hooked	14	53	2055	2	hooked
irked	10	45	1092	2	ir_ked
ironed	7	49	1601	2	ironed
joked	17	52	1791	2	_joked
looked	11	47	1707	2	looked
poked	12	54	2539	2	_poked
porked	13	47	1762	2	porked
probed	11	41	1482	2	probed
prosed	9	49	2109	2	prosed
proved	12	50	1603	2	proved
raked	10	58	3142	2	_raked
robed	8	53	2373	2	_robed
rocked	13	50	2232	2	_rocked
rooked	11	49	1814	2	rooked
roped	8	46	3080	2	_roped
rosed	6	59	3034	2	_rosed
roved	9	53	2355	2	_roved
rowed	9	40	3432	2	_rowed
ryked	13	66	951	2	_ryked
smoked	13	43	1172	2	smoked
spoked	13	44	1389	2	spoked
stoked	11	47	1829	2	stoked
stooked	12	43	1230	2	stooked
straked	12	54	1534	2	straked
stroke	10	51	1617	2	stroke_
stroker	11	41	1352	2	stroker
strokes	11	43	1632	2	strokes
strowed	11	53	1214	2	strowed
stroyed	11	41	1086	2	stroyed
tacked	13	47	2394	2	tacked
talked	11	40	1540	2	talked
tanked	11	39	1929	2	tanked
tasked	11	47	1464	2	tasked
tholed	10	51	1387	2	tholed
thoued	10	42	900	2	thoued
throned	11	54	1217	2	throned
ticked	13	47	2052	2	ticked
toed	5	61	3704	2	t_o_ed
toke	8	67	3849	2	t_oke_
token	9	54	1931	2	t_oken
toker	9	59	2491	2	t_oker
tokes	9	52	3497	2	t_okes
toled	6	59	3492	2	t_oled
toned	6	54	3534	2	t_oned
tooled	7	49	1890	2	tooled
tooted	7	46	2012	2	tooted
toped	8	56	3131	2	t_oped
toted	6	49	2948	2	t_oted
towed	9	51	3458	2	t_owed
toyed	9	60	1980	2	t_oyed
traced	9	48	2158	2	traced
tracked	14	37	1613	2	tracked
traded	8	57	1768	2	traded
traiked	12	33	1045	2	traiked
treed	6	56	2673	2	tr_eed
trekked	11	3	434	2	trekked
triced	9	55	1867	2	triced
tricked	14	40	1616	2	tricked
tried	6	50	2691	2	tr_ied
trike	9	53	2016	2	trike_
trikes	10	54	1949	2	trikes
trined	7	49	2071	2	trined
trod	5	76	2795	2	tro__d
trode	6	53	2285	2	trode_
trolled	8	43	1226	2	trolled
tromped	12	42	1029	2	tromped
trone	5	51	3186	2	trone_
trones	6	56	2928	2	trones
trooped	10	40	1072	2	trooped
trope	7	57	2580	2	trope_
tropes	8	48	2435	2	tropes
trothed	11	40	1097	2	trothed
trotted	8	37	1128	2	trotted
trouped	10	39	1098	2	trouped
trove	8	52	2192	2	trove_
trover	9	50	1466	2	trover
troves	9	47	1911	2	troves
trowel	9	42	1146	2	trowel
truced	9	53	1205	2	truced
trucked	14	39	1081	2	trucked
trued	6	51	1769	2	tr_ued
trunked	12	35	841	2	trunked
tsked	10	59	1003	2	t_sked
tucked	13	40	1749	2	tucked
tusked	11	41	1215	2	tusked
worked	14	53	1470	2	worked
yoked	13	48	2162	2	_yoked

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	0.343	520965.0
2	DLD Change Limit	82551	123	2.736	30172.1
3	Display Results	123	123	0.030	4100.0
	(SQL Overall)	178691	123	3.109	57475.4