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

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

105 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
talky	12	62	1568	(None)
alky	11	59	2034	1	_alky
balky	14	54	1824	1	balky
stalky	13	49	930	1	stalky
tacky	14	56	1744	1	tacky
talcky	15	29	472	1	talcky
talk	8	62	3009	1	talk_
talks	9	43	2269	1	talks
tally	8	45	2686	1	tally
alkyd	13	53	709	2	_alkyd
alkyl	12	51	804	2	_alkyl
ally	7	69	3564	2	_ally
baldy	11	55	1893	2	baldy
balk	10	51	3222	2	balk_
balks	11	49	2629	2	balks
bally	10	55	3010	2	bally
balmy	12	52	1747	2	balmy
barky	14	57	2161	2	barky
baulky	15	44	631	2	baulky
bulky	14	62	1557	2	bulky
caky	13	62	2244	2	ca_ky
calk	10	55	2766	2	calk_
calks	11	54	2160	2	calks
casky	14	45	1268	2	casky
chalky	18	46	877	2	chalky
dally	9	53	2474	2	dally
darky	13	60	1883	2	darky
flaky	15	57	1558	2	flaky
folky	15	92	1471	2	folky
gally	9	50	2617	2	gally
gawky	16	56	999	2	gawky
hanky	15	54	1829	2	hanky
hulky	15	53	1247	2	hulky
jacky	21	54	1234	2	jacky
laky	11	67	2582	2	la_ky
lanky	12	55	1748	2	lanky
larky	12	52	1887	2	larky
malmy	12	48	1634	2	malmy
malty	10	67	2170	2	malty
milky	14	40	1444	2	milky
narky	12	60	1780	2	narky
oaky	11	64	1995	2	oa_ky
otalgy	10	3	535	2	otalgy
pally	10	57	2712	2	pally
palmy	12	60	1673	2	palmy
palsy	10	54	1746	2	palsy
paly	9	58	3553	2	pal_y
pawky	17	38	1015	2	pawky
rally	8	47	2590	2	rally
sally	8	51	2971	2	sally
salty	8	55	2438	2	salty
sarky	12	55	2178	2	sarky
silky	12	53	1582	2	silky
stalk	9	45	1800	2	stalk_
stalks	10	46	1455	2	stalks
sulky	12	47	1536	2	sulky
tabby	12	52	1389	2	tabby
tack	10	65	3629	2	tack_
tackey	15	46	1308	2	tackey
tacks	11	54	3013	2	tacks
taffy	14	51	1082	2	taffy
taka	8	76	2359	2	ta_ka
take	8	47	3926	2	ta_ke
tala	4	59	3805	2	tal_a
talar	5	62	2538	2	talar
talas	5	59	3589	2	talas
talc	6	62	2681	2	tal_c
talcs	7	48	1718	2	talcs
tale	4	61	5416	2	tal_e
taler	5	60	3486	2	taler
tales	5	54	5137	2	tales
tali	4	68	3716	2	tal_i
talked	11	40	1540	2	talked
talker	10	39	1622	2	talker
talkie	10	39	1444	2	talkie
tall	4	72	4021	2	tal_l
talls	5	51	3343	2	talls
talon	5	58	2411	2	talon
taluk	9	48	1287	2	taluk
taluka	10	42	677	2	taluka
taluks	10	41	828	2	taluks
talus	5	54	2326	2	talus
tammy	12	40	1322	2	tammy
tangy	9	45	1993	2	tangy
tank	8	51	3402	2	tank_
tanka	9	38	1748	2	tanka
tanks	9	46	2473	2	tanks
tansy	8	45	1493	2	tansy
tardy	9	47	2046	2	tardy
tarry	8	54	2251	2	tarry
tarty	8	63	2818	2	tarty
task	8	53	2665	2	task_
tasks	9	49	1758	2	tasks
tasty	8	48	2031	2	tasty
tatty	8	47	2018	2	tatty
tawny	11	47	1365	2	tawny
telly	8	49	2082	2	telly
twanky	16	44	577	2	twanky
valkyr	16	3	240	2	valkyr
wacky	17	47	1493	2	wacky
walk	11	56	2561	2	walk_
walks	12	62	1850	2	walks
wally	11	46	2509	2	wally
waly	10	58	3090	2	wal_y
yolky	15	52	952	2	yolky

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	53800	0.313	570897.8
2	DLD Change Limit	53800	105	1.656	32487.9
3	Display Results	105	105	0.030	3500.0
	(SQL Overall)	178691	105	1.999	89390.2