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

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

94 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
thick	14	56	1335	(None)
chick	16	54	1913	1	chick
hick	13	55	3030	1	_hick
thack	14	49	1517	1	thack
thicks	15	45	1199	1	thicks
think	12	50	1880	1	think
tick	10	62	3122	1	t_ick
trick	11	54	2069	1	trick
brick	13	46	1815	2	brick
check	16	47	1471	2	check
chic	11	59	2520	2	chic_
chica	12	58	1826	2	chica
chicks	17	53	1759	2	chicks
chico	12	42	1825	2	chico
chics	12	39	2094	2	chics
chink	14	53	2159	2	chink
chirk	14	45	1618	2	chirk
chock	16	43	1661	2	chock
chuck	16	48	1487	2	chuck
click	13	52	1795	2	click
crick	13	51	1875	2	crick
dick	11	64	3238	2	_dick
ethic	10	15	1122	2	ethic_
ethics	11	16	928	2	ethics
flick	14	50	1721	2	flick
hack	13	51	3454	2	_hack
heck	13	58	2649	2	_heck
hic	8	65	4056	2	_hic_
hicks	14	53	2217	2	_hicks
hock	13	60	3130	2	_hock
hoick	14	52	1068	2	hoick
huck	13	59	2763	2	_huck
ick	9	73	2932	2	__ick
kick	9	60	2607	2	_kick
klick	10	53	1143	2	klick
lick	10	69	3507	2	_lick
mick	12	63	3343	2	_mick
nick	10	66	2760	2	_nick
pick	12	59	3381	2	_pick
prick	13	43	1750	2	prick
quick	20	43	1106	2	quick
rick	10	73	3465	2	_rick
shack	14	53	2175	2	shack
shirk	12	48	1784	2	shirk
shock	14	49	1703	2	shock
shtick	15	30	802	2	shtick
shuck	14	43	1453	2	shuck
sick	10	64	3557	2	_sick
slick	11	55	2052	2	slick
snick	11	44	1601	2	snick
spick	13	45	1907	2	spick
stick	11	51	2156	2	stick
strick	12	48	1320	2	strick
tack	10	65	3629	2	t_ack
thacks	15	43	1192	2	thacks
thank	12	58	1780	2	thank
theca	10	33	1145	2	theca
thicken	16	31	787	2	thicken
thicker	16	36	1102	2	thicker
thicket	16	32	1307	2	thicket
thickly	19	41	557	2	thickly
thief	11	45	1630	2	thief
thigh	12	4	1012	2	thigh
thill	8	59	1873	2	thill
thin	7	67	3239	2	thi_n
thine	8	50	2686	2	thine
thing	9	66	2298	2	thing
thinks	13	46	1336	2	thinks
thins	8	58	2633	2	thins
thio	7	72	2541	2	thi_o
thiol	8	76	1604	2	thiol
thir	7	64	2054	2	thi_r
third	9	59	1249	2	third
thirl	8	54	1682	2	thirl
this	7	60	2738	2	thi_s
thrice	11	43	1157	2	thrice
thunk	12	49	1185	2	thunk
thwack	18	3	421	2	thwack
tic	5	63	4346	2	t_ic_
ticks	11	58	2329	2	t_icks
tics	6	57	2963	2	t_ics
track	11	48	2301	2	track
trice	7	51	2749	2	trice
tricks	12	53	1901	2	tricks
tricky	15	42	1147	2	tricky
trock	11	48	1760	2	trock
truck	11	61	1546	2	truck
tuck	10	46	2657	2	t_uck
twice	10	47	1112	2	twice
whack	17	48	1302	2	whack
which	16	39	1008	2	which
whisk	15	45	1014	2	whisk
wick	13	57	2630	2	_wick
wrick	14	40	1339	2	wrick

Search took 2 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	53800	0.296	603685.8
2	DLD Change Limit	53800	94	1.546	34799.5
3	Display Results	94	94	0.033	2848.5
	(SQL Overall)	178691	94	1.875	95301.9