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

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

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.

93 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
thwacker	20	4	287	(None)
thwacked	21	3	272	1	thwacked
thwackers	21	4	222	1	thwackers
hacker	15	48	2269	2	_h_acker
tacker	12	42	2450	2	t__acker
thacked	17	38	1020	2	th_acked
thanker	14	30	959	2	th_anker
thicker	16	36	1102	2	th_icker
thwack	18	3	421	2	thwack__
thwacks	19	5	361	2	thwack_s
thwarter	14	3	339	2	thwarter
tracker	13	35	1517	2	t_racker
wacker	15	49	2012	2	__wacker
whacker	19	36	850	2	wh_acker
attacker	14	14	498	3	attacker
backer	14	45	2553	3	__backer
blacker	15	45	1351	3	_blacker
checker	18	32	953	3	ch_ecker
clacker	15	38	1377	3	_clacker
cracker	15	31	1417	3	_cracker
dacker	13	49	2075	3	__dacker
hacked	16	49	2351	3	_h_acked
hackee	15	49	2183	3	_h_ackee
hackers	16	46	1904	3	_h_ackers
hackler	16	35	1235	3	_h_ackler
hanker	13	46	2209	3	_h_anker
hawker	16	48	1266	3	_h_awker
hijacker	24	4	246	3	hijacker
hocker	15	51	1856	3	_h_ocker
jacker	19	44	1758	3	__jacker
knacker	12	30	791	3	_knacker
lacker	12	53	2562	3	__lacker
packer	14	42	2340	3	__packer
racker	12	48	2455	3	__racker
sacker	12	51	2484	3	__sacker
shacked	17	40	1539	3	sh_acked
shackler	17	31	797	3	sh_ackler
shaker	13	43	1946	3	sh_a_ker
sharker	14	43	1381	3	sh_arker
shicker	16	39	1482	3	sh_icker
shocker	16	34	1143	3	sh_ocker
shucker	16	37	1010	3	sh_ucker
slacker	13	39	1529	3	_slacker
smacker	15	34	1058	3	_smacker
snacker	13	31	1260	3	_snacker
stacker	13	44	1626	3	_stacker
swacked	17	31	1052	3	_swacked
swanker	14	36	948	3	_swanker
tacked	13	47	2394	3	t__acked
tackers	13	43	1962	3	t__ackers
tacket	12	46	2749	3	t__acket
tackey	15	46	1308	3	t__ackey
tackier	13	37	1252	3	t__ackier
tackler	13	40	1332	3	t__ackler
taker	9	52	2900	3	t__a_ker
talker	10	39	1622	3	t__alker
tanker	10	45	2113	3	t__anker
teacher	12	37	1483	3	t_eacher
thack	14	49	1517	3	th_ack__
thacks	15	43	1192	3	th_ack_s
thaler	9	46	1310	3	th_a_ler
thanked	15	46	915	3	th_anked
thankers	15	29	783	3	th_ankers
thatcher	16	3	566	3	thatcher
thawer	12	48	934	3	th_a_wer
theater	10	40	1425	3	thea_ter
thicken	16	31	787	3	th_icken
thicket	16	32	1307	3	th_icket
thinker	14	36	1068	3	th_inker
thrasher	14	5	574	3	thrasher
thwacking	22	5	319	3	thwacking
thwarted	15	3	336	3	thwarted
thwarters	15	4	284	3	thwarters
ticker	12	43	2150	3	t__icker
tracer	8	48	2023	3	t_rac_er
tracked	14	37	1613	3	t_racked
trackers	14	35	1285	3	t_rackers
tricker	13	46	1552	3	t_ricker
trucker	13	40	1073	3	t_rucker
tucker	12	43	1695	3	t__ucker
twanger	11	32	744	3	t_wanger
unpacker	16	21	589	3	unpacker
wacke	14	59	1862	3	__wacke_
wackes	15	47	1771	3	__wackes
wackier	16	36	973	3	__wackier
waker	12	55	2659	3	__wa_ker
walker	13	39	1399	3	__walker
wanker	13	42	1997	3	__wanker
whacked	20	45	862	3	wh_acked
whackers	20	32	654	3	wh_ackers
whackier	20	4	467	3	wh_ackier
whicker	19	35	977	3	wh_icker
wicker	15	45	1867	3	__wicker

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	93	6.983	20931.1
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	7.419	24085.6