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

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

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

106 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
thwacked	21	3	272	(None)
thacked	17	38	1020	1	th_acked
thwacker	20	4	287	1	thwacker
hacked	16	49	2351	2	_h_acked
shacked	17	40	1539	2	sh_acked
swacked	17	31	1052	2	_swacked
tacked	13	47	2394	2	t__acked
thanked	15	46	915	2	th_anked
thwack	18	3	421	2	thwack__
thwackers	21	4	222	2	thwackers
thwacks	19	5	361	2	thwack_s
thwarted	15	3	336	2	thwarted
tracked	14	37	1613	2	t_racked
whacked	20	45	862	2	wh_acked
attacked	15	12	511	3	attacked
awaked	14	57	920	3	_awa_ked
backed	15	57	2572	3	__backed
blacked	16	36	1337	3	_blacked
chalked	17	44	986	3	ch_alked
charked	17	48	1401	3	ch_arked
checked	19	37	1002	3	ch_ecked
chocked	19	44	1161	3	ch_ocked
chucked	19	46	973	3	ch_ucked
clacked	16	41	1360	3	_clacked
cracked	16	35	1474	3	_cracked
flacked	17	37	1158	3	_flacked
hackee	15	49	2183	3	_h_ackee
hacker	15	48	2269	3	_h_acker
hackled	17	33	1249	3	_h_ackled
hanked	14	42	2060	3	_h_anked
harked	14	54	2255	3	_h_arked
hawked	17	47	1267	3	_h_awked
hijacked	25	4	237	3	hijacked
hocked	16	55	2130	3	_h_ocked
hoicked	17	3	596	3	_hoicked
jacked	20	48	1752	3	__jacked
knacked	13	28	779	3	_knacked
lacked	13	53	2465	3	__lacked
packed	15	48	2260	3	__packed
quacked	23	3	679	3	_quacked
racked	13	45	2608	3	__racked
repacked	17	18	874	3	repacked
reracked	15	16	912	3	reracked
retacked	15	16	927	3	retacked
rewaked	15	38	1190	3	rewa_ked
sacked	13	55	2521	3	__sacked
shackled	18	27	760	3	sh_ackled
shanked	15	32	1212	3	sh_anked
sharked	15	36	1391	3	sh_arked
shocked	17	46	1181	3	sh_ocked
shucked	17	38	983	3	sh_ucked
slacked	14	38	1545	3	_slacked
smacked	16	37	1099	3	_smacked
snacked	14	40	1311	3	_snacked
stacked	14	34	1612	3	_stacked
swanked	15	35	954	3	_swanked
tacker	12	42	2450	3	t__acker
tacket	12	46	2749	3	t__acket
tackey	15	46	1308	3	t__ackey
tackled	14	39	1319	3	t__ackled
talcked	14	4	634	3	t_alcked
talked	11	40	1540	3	t__alked
tanked	11	39	1929	3	t__anked
tarmacked	18	4	377	3	tarmacked
tasked	11	47	1464	3	t__asked
thack	14	49	1517	3	th_ack__
thacks	15	43	1192	3	th_ack_s
thanker	14	30	959	3	th_anker
thatched	17	3	543	3	thatched
thawed	13	45	846	3	th_a_wed
thicken	16	31	787	3	th_icken
thicker	16	36	1102	3	th_icker
thicket	16	32	1307	3	th_icket
thralled	12	4	580	3	thralled
thrashed	15	5	536	3	thrashed
thrawed	14	3	558	3	thra_wed
thunked	15	38	685	3	th_unked
thwacking	22	5	319	3	thwacking
thwarter	14	3	339	3	thwarter
ticked	13	47	2052	3	t__icked
tictacked	18	15	305	3	tictacked
traced	9	48	2158	3	t_rac_ed
tracker	13	35	1517	3	t_racker
traiked	12	33	1045	3	t_raiked
tricked	14	40	1616	3	t_ricked
troaked	12	43	825	3	troa_ked
trocked	14	43	1224	3	t_rocked
trucked	14	39	1081	3	t_rucked
tucked	13	40	1749	3	t__ucked
twanged	12	38	727	3	t_wanged
tweaked	15	3	440	3	t_weaked
unbacked	17	26	873	3	unbacked
unpacked	17	26	866	3	unpacked
untacked	15	23	992	3	untacked
wacke	14	59	1862	3	__wacke_
wacker	15	49	2012	3	__wacker
wackes	15	47	1771	3	__wackes
waked	13	56	2675	3	__wa_ked
walked	14	53	1378	3	__walked
wanked	14	45	1715	3	__wanked
warked	14	44	2121	3	__warked
wauked	14	42	1057	3	__wauked
whacker	19	36	850	3	wh_acker
wicked	16	43	1741	3	__wicked
wracked	17	41	1011	3	_wracked
yacked	16	45	1679	3	__yacked

Search took 8 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	146162	0.406	440125.6
2	DLD Change Limit	146162	106	6.953	21021.4
3	Display Results	106	106	0.033	3212.1
	(SQL Overall)	178691	106	7.392	24173.6