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

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

56 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
thanking	16	40	952	(None)
hanking	15	46	1910	1	_hanking
shanking	16	36	1228	1	shanking
tanking	12	39	1879	1	t_anking
thacking	18	31	1004	1	thacking
thinking	16	28	986	1	thinking
thunking	16	19	695	1	thunking
banking	14	46	2135	2	_banking
bethanking	20	4	429	2	bethanking
blanking	15	44	1193	2	blanking
chalking	18	33	1006	2	chalking
chancing	16	28	1028	2	chancing
changing	15	32	1151	2	changing
chanting	14	34	1353	2	chanting
charking	18	35	1261	2	charking
chinking	18	32	1089	2	chinking
chunking	18	32	805	2	chunking
clanking	15	43	1306	2	clanking
cranking	15	46	1307	2	cranking
flanking	16	42	1108	2	flanking
franking	16	43	1086	2	franking
hacking	17	37	2061	2	_hacking
handing	12	35	1889	2	_handing
hanging	12	35	1870	2	_hanging
hanting	11	41	2448	2	_hanting
harking	15	41	2094	2	_harking
hawking	18	37	1142	2	_hawking
honking	15	34	1479	2	_honking
planking	15	35	1301	2	planking
pranking	15	38	1338	2	pranking
ranking	12	43	2088	2	_ranking
shacking	18	40	1408	2	shacking
shaking	15	33	1725	2	sha_king
sharking	16	39	1297	2	sharking
skanking	12	28	874	2	skanking
spanking	15	39	1197	2	spanking
swanking	16	39	996	2	swanking
tacking	14	44	2148	2	t_acking
taking	11	47	2595	2	t_a_king
talking	12	38	1582	2	t_alking
tanging	9	34	1952	2	t_anging
tankini	11	33	892	2	t_ankini
tanning	8	36	1825	2	t_anning
tasking	12	46	1632	2	t_asking
thawing	14	37	868	2	tha_wing
thinkings	17	25	505	2	thinkings
thinning	12	31	909	2	thinning
thwacking	22	5	319	2	thwacking
tracking	15	37	1546	2	tracking
traiking	13	25	1197	2	traiking
trancing	11	28	1202	2	trancing
twanging	13	28	706	2	twanging
wanking	15	42	1678	2	_wanking
whacking	21	37	748	2	whacking
whanging	16	26	714	2	whanging
yanking	15	45	1246	2	_yanking

Search took 4 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.140	1276364.3
2	DLD Change Limit	121059	56	3.280	36908.2
3	Display Results	56	56	0.033	1697.0
	(SQL Overall)	178691	56	3.453	51749.5