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

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

77 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
thwackers	21	4	222	(None)
thwacker	20	4	287	1	thwacker_
hackers	16	46	1904	2	_h_ackers
tackers	13	43	1962	2	t__ackers
thankers	15	29	783	2	th_ankers
thwacked	21	3	272	2	thwacke_d
thwacks	19	5	361	2	thwack__s
thwarters	15	4	284	2	thwarters
trackers	14	35	1285	2	t_rackers
whackers	20	32	654	2	wh_ackers
attackers	15	14	401	3	attackers
backers	15	38	2188	3	__backers
checkers	19	31	784	3	ch_eckers
clackers	16	39	1170	3	_clackers
crackers	16	41	1172	3	_crackers
dackers	14	34	1704	3	__dackers
hackees	16	50	1410	3	_h_ackees
hacker	15	48	2269	3	_h_acker_
hacklers	17	37	1030	3	_h_acklers
hankers	14	42	1813	3	_h_ankers
hawkers	17	42	1033	3	_h_awkers
hijackers	25	4	232	3	hijackers
hockers	16	39	1591	3	_h_ockers
jackers	20	42	1445	3	__jackers
knackers	13	28	684	3	_knackers
lackers	13	41	2054	3	__lackers
packers	15	38	1889	3	__packers
rackers	13	43	2045	3	__rackers
sackers	13	38	2022	3	__sackers
shacklers	18	33	603	3	sh_acklers
shakers	14	40	1556	3	sh_a_kers
sharkers	15	40	1105	3	sh_arkers
shickers	17	30	1282	3	sh_ickers
shockers	17	31	946	3	sh_ockers
shuckers	17	38	813	3	sh_uckers
slackers	14	38	1274	3	_slackers
smackers	16	31	871	3	_smackers
snackers	14	30	1022	3	_snackers
stackers	14	34	1356	3	_stackers
tacker	12	42	2450	3	t__acker_
tackets	13	49	1436	3	t__ackets
tacklers	14	30	1077	3	t__acklers
takers	10	39	2374	3	t__a_kers
talkers	11	35	1321	3	t__alkers
tankers	11	34	1691	3	t__ankers
teachers	13	32	1239	3	t_eachers
thacked	17	38	1020	3	th_acke_d
thacks	15	43	1192	3	th_ack__s
thalers	10	62	1226	3	th_a_lers
thanker	14	30	959	3	th_anker_
thatchers	17	4	458	3	thatchers
thawers	13	42	848	3	th_a_wers
theaters	11	42	1190	3	thea_ters
thickens	17	26	641	3	th_ickens
thicker	16	36	1102	3	th_icker_
thickets	17	28	708	3	th_ickets
thinkers	15	30	870	3	th_inkers
thrashers	15	6	531	3	thrashers
thwack	18	3	421	3	thwack___
thwacking	22	5	319	3	thwacking
thwarter	14	3	339	3	thwarter_
tickers	13	36	1772	3	t__ickers
tracers	9	49	1784	3	t_rac_ers
tracker	13	35	1517	3	t_racker_
trickers	14	38	1281	3	t_rickers
truckers	14	27	901	3	t_ruckers
tuckers	13	40	1435	3	t__uckers
twangers	12	22	606	3	t_wangers
unpackers	17	20	381	3	unpackers
wacker	15	49	2012	3	__wacker_
wackes	15	47	1771	3	__wacke_s
wakers	13	48	2249	3	__wa_kers
walkers	14	34	1147	3	__walkers
wankers	14	45	1471	3	__wankers
whacker	19	36	850	3	wh_acker_
whickers	20	29	798	3	wh_ickers
wickers	16	41	1470	3	__wickers

Search took 7 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	148641	0.156	1145455.1
2	DLD Change Limit	148641	77	6.766	21968.8
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.952	25703.5