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

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

97 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
worked	14	53	1470	1	worked
worker	13	47	1511	1	worker
workers	14	46	1269	1	workers
works	12	56	2190	1	work_s
worses	9	55	2295	1	worses
bores	7	64	4825	2	bor_es
borked	13	51	1729	2	borked
borks	11	57	2770	2	bork_s
burkes	12	44	2131	2	burkes
cokes	11	55	3719	2	co_kes
cores	7	63	6185	2	cor_es
corked	13	50	2078	2	corked
corker	12	47	2085	2	corker
corkers	13	41	1885	2	corkers
corks	11	60	2827	2	cork_s
corses	8	44	3346	2	corses
corves	11	51	2252	2	corves
dories	7	52	3236	2	dories
dorks	10	57	2444	2	dork_s
forces	11	44	2213	2	forces
fores	8	58	4710	2	for_es
forges	10	50	2426	2	forges
forked	14	52	1714	2	forked
forker	13	47	1790	2	forker
forkers	14	46	1578	2	forkers
forks	12	53	2468	2	fork_s
formes	11	46	2371	2	formes
fortes	9	53	2718	2	fortes
gores	6	57	4037	2	gor_es
gorges	8	53	2189	2	gorges
gorses	7	47	2329	2	gorses
hokes	12	62	3164	2	ho_kes
hordes	10	49	2163	2	hordes
horses	9	47	2935	2	horses
jokes	16	54	2333	2	jo_kes
lores	5	50	4540	2	lor_es
lories	6	49	3304	2	lories
mokes	11	46	3103	2	mo_kes
mores	7	62	4964	2	mor_es
okes	8	49	3634	2	_o_kes
ores	4	60	5668	2	_or_es
orles	5	53	2621	2	_orles
pokes	11	61	3301	2	po_kes
pores	7	58	4903	2	por_es
porked	13	47	1762	2	porked
porker	12	49	1754	2	porker
porkers	13	43	1493	2	porkers
porkies	13	34	1649	2	porkies
porks	11	51	2414	2	pork_s
sokes	9	50	3142	2	so_kes
sores	5	54	5428	2	sor_es
tokes	9	52	3497	2	to_kes
tores	5	53	5267	2	tor_es
tories	6	54	3588	2	tories
torses	6	47	2795	2	torses
tortes	6	48	2605	2	tortes
trokes	10	40	1926	2	trokes
wackes	15	47	1771	2	wackes
wakes	12	66	3365	2	w_akes
wares	8	82	5058	2	war_es
warked	14	44	2121	2	warked
warks	12	79	3240	2	wark_s
whores	12	56	1710	2	whor_es
wires	8	60	3491	2	wir_es
wodges	11	74	1368	2	wodges
woes	7	64	4066	2	wo__es
woke	11	55	2796	2	wo_ke_
woken	12	46	1497	2	wo_ken
woks	11	62	2490	2	wo_k_s
wolves	12	45	1085	2	wolves
wonks	12	48	1834	2	wonk_s
worded	11	43	1662	2	worded
words	9	54	2507	2	wor_ds
wore	7	71	4467	2	wor_e_
work	11	55	2884	2	work__
workless	15	27	680	2	workless
workmen	16	3	593	2	workmen
workup	15	3	432	2	workup
workups	16	3	361	2	workups
worlds	10	56	873	2	worlds
wormed	12	43	1430	2	wormed
wormer	11	45	1491	2	wormer
wormers	12	40	1257	2	wormers
worms	10	53	2076	2	wor_ms
worries	10	41	1713	2	worries
worse	8	65	2526	2	worse_
worsen	9	55	1387	2	worsen
worsens	10	46	1026	2	worsens
worser	9	51	1752	2	worser
worset	9	67	2658	2	worset
worsets	10	55	1284	2	worsets
worsts	9	60	1433	2	worsts
worths	12	78	1289	2	worths
worts	8	86	3118	2	wor_ts
wries	8	58	2774	2	w_ries
yokes	12	52	2302	2	yo_kes
yores	8	50	3132	2	yor_es

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.326	548131.9
2	DLD Change Limit	82551	97	2.253	36640.5
3	Display Results	97	97	0.030	3233.3
	(SQL Overall)	178691	97	2.609	68490.2