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

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

86 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
thanks	13	43	1313	(None)
hanks	12	62	2686	1	_hanks
shanks	13	53	1558	1	shanks
tanks	9	46	2473	1	t_anks
thacks	15	43	1192	1	thacks
thanes	9	49	1898	1	thanes
thank	12	58	1780	1	thank_
thinks	13	46	1335	1	thinks
thunks	13	45	903	1	thunks
tranks	10	40	1776	1	tranks
banks	11	55	2790	2	_banks
bethanks	17	6	531	2	bethanks
bhangs	12	44	966	2	bhangs
blanks	12	41	1289	2	blanks
branks	12	48	1738	2	branks
chalks	15	54	1214	2	chalks
changs	12	52	1537	2	changs
chants	11	50	2039	2	chants
charks	15	52	1970	2	charks
chinks	15	58	1757	2	chinks
chunks	15	42	1033	2	chunks
clanks	12	46	1518	2	clanks
cranks	12	50	1531	2	cranks
dhaks	13	47	970	2	dha_ks
ethanes	10	37	1350	2	ethanes
flanks	13	39	1340	2	flanks
franks	13	49	1273	2	franks
hacks	14	49	2871	2	_hacks
haiks	12	51	2093	2	_haiks
hands	9	53	2738	2	_hands
hangs	9	57	2672	2	_hangs
hank	11	51	3413	2	_hank_
hanky	15	54	1829	2	_hanky
hants	8	63	3540	2	_hants
harks	12	63	3343	2	_harks
hawks	15	54	1570	2	_hawks
honks	12	51	2452	2	_honks
hunks	12	53	2145	2	_hunks
khans	12	46	1517	2	khan_s
planks	12	41	1675	2	planks
pranks	12	48	1472	2	pranks
ranks	9	52	2573	2	_ranks
shacks	15	48	1756	2	shacks
shank	12	54	2219	2	shank_
sharks	13	50	1972	2	sharks
skanks	9	47	1083	2	skanks
spanks	12	45	1412	2	spanks
stanks	10	49	1770	2	stanks
swanks	13	48	1156	2	swanks
tacks	11	54	3013	2	t_acks
talks	9	43	2269	2	t_alks
tangs	6	50	2834	2	t_angs
tank	8	51	3401	2	t_ank_
tanka	9	38	1748	2	t_anka
tankas	10	46	1376	2	t_ankas
tans	4	61	5481	2	t_an_s
tasks	9	49	1758	2	t_asks
teaks	9	42	2290	2	tea_ks
thack	14	49	1517	2	thack_
than	7	61	2877	2	than__
thane	8	61	2253	2	than_e
thanked	15	46	915	2	thanked
thanker	14	30	959	2	thanker
thankers	15	29	783	2	thankers
tharms	11	57	1224	2	tharms
thaws	11	65	1546	2	tha_ws
thens	8	59	2183	2	then_s
thicks	15	45	1199	2	thicks
things	10	49	1428	2	things
think	12	50	1879	2	think_
thins	8	58	2632	2	thin_s
thongs	10	46	1118	2	thongs
thunk	12	49	1185	2	thunk_
thwacks	19	5	361	2	thwacks
tracks	12	48	1884	2	tracks
traiks	10	40	1371	2	traiks
trank	9	62	2242	2	trank_
tranqs	15	52	1031	2	tranqs
trans	5	49	3304	2	tran_s
trunks	10	42	975	2	trunks
twangs	10	35	809	2	twangs
twanky	16	44	577	2	twanky
wanks	12	61	2448	2	_wanks
whacks	18	46	1048	2	whacks
whangs	13	43	972	2	whangs
yanks	12	53	1657	2	_yanks

Search took 3 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	82551	0.126	1418182.5
2	DLD Change Limit	82551	86	2.530	32628.9
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	2.686	66526.8