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

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

62 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
thacking	18	31	1004	(None)
hacking	17	37	2061	1	_hacking
shacking	18	40	1408	1	shacking
tacking	14	44	2148	1	t_acking
thanking	16	40	952	1	thanking
thwacking	22	5	319	1	thwacking
tracking	15	37	1546	1	tracking
whacking	21	37	748	1	whacking
attacking	16	3	532	2	attacking
backing	16	55	2344	2	_backing
blacking	17	42	1360	2	blacking
chalking	18	33	1006	2	chalking
charking	18	35	1261	2	charking
checking	20	37	920	2	checking
chocking	20	40	1101	2	chocking
chucking	20	37	950	2	chucking
clacking	17	33	1349	2	clacking
cracking	17	40	1390	2	cracking
flacking	18	43	1179	2	flacking
hackling	18	33	1016	2	_hackling
hanking	15	46	1910	2	_hanking
harking	15	41	2094	2	_harking
hawking	18	37	1142	2	_hawking
hocking	17	34	1724	2	_hocking
jacking	21	45	1526	2	_jacking
knacking	14	29	671	2	knacking
lacking	14	38	2154	2	_lacking
packing	16	44	2072	2	_packing
quacking	24	3	674	2	quacking
racking	14	43	2366	2	_racking
sacking	14	41	2270	2	_sacking
shackling	19	28	617	2	shackling
shaking	15	33	1725	2	sha_king
shanking	16	36	1228	2	shanking
sharking	16	39	1297	2	sharking
shocking	18	43	1154	2	shocking
shucking	18	33	943	2	shucking
slacking	15	39	1413	2	slacking
smacking	17	35	1076	2	smacking
snacking	15	34	1170	2	snacking
stacking	15	42	1508	2	stacking
tackling	15	32	1112	2	t_ackling
taking	11	47	2595	2	t_a_king
talcking	15	6	708	2	talcking
talking	12	38	1582	2	t_alking
tanking	12	39	1879	2	t_anking
tasking	12	46	1632	2	t_asking
teaching	14	36	1260	2	teaching
thatching	18	3	514	2	thatching
thawing	14	37	868	2	tha_wing
thinking	16	28	986	2	thinking
thunking	16	19	695	2	thunking
ticking	14	32	1875	2	t_icking
tracing	10	37	2015	2	trac_ing
trackings	16	24	754	2	trackings
traiking	13	25	1197	2	traiking
tricking	15	27	1451	2	tricking
trocking	15	36	1242	2	trocking
trucking	15	33	1016	2	trucking
tucking	14	34	1518	2	t_ucking
wracking	18	34	996	2	wracking
yacking	17	43	1568	2	_yacking

Search took 6 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	121059	0.766	233278.1
2	DLD Change Limit	121059	62	4.390	27576.1
3	Display Results	62	62	0.016	3875.0
	(SQL Overall)	178691	62	5.172	34549.7