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

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

88 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
thicks	15	45	1199	(None)
chicks	17	53	1759	1	chicks
hicks	14	53	2217	1	_hicks
thacks	15	43	1192	1	thacks
thick	14	56	1335	1	thick_
thinks	13	46	1336	1	thinks
ticks	11	58	2329	1	t_icks
tricks	12	53	1901	1	tricks
bricks	14	46	1462	2	bricks
checks	17	49	1270	2	checks
chicas	13	59	1647	2	chicas
chick	16	54	1913	2	chick_
chicos	13	46	1483	2	chicos
chics	12	39	2094	2	chic_s
chinks	15	58	1757	2	chinks
chirks	15	54	1484	2	chirks
chocks	17	48	1531	2	chocks
chucks	17	48	1293	2	chucks
clicks	14	53	1511	2	clicks
cricks	14	43	1605	2	cricks
dicks	12	58	2469	2	_dicks
ethics	11	16	928	2	ethic_s
flicks	15	45	1299	2	flicks
hacks	14	49	2871	2	_hacks
hecks	14	52	2065	2	_hecks
hick	13	55	3031	2	_hick_
hocks	14	49	2549	2	_hocks
hoicks	15	37	828	2	hoicks
hucks	14	43	2217	2	_hucks
kicks	10	44	2009	2	_kicks
klicks	11	46	872	2	klicks
licks	11	53	2539	2	_licks
micks	13	55	2537	2	_micks
nicks	11	49	2049	2	_nicks
picks	13	52	2614	2	_picks
pricks	14	44	1426	2	pricks
quicks	21	38	930	2	quicks
ricks	11	51	2613	2	_ricks
shacks	15	48	1756	2	shacks
shicksa	16	3	410	2	shicksa
shirks	13	48	1412	2	shirks
shocks	15	44	1458	2	shocks
shticks	16	35	696	2	shticks
shucks	15	40	1041	2	shucks
sicks	11	51	2762	2	_sicks
slicks	12	48	1611	2	slicks
snicks	12	43	1247	2	snicks
spicks	14	48	1499	2	spicks
sticks	12	51	1861	2	sticks
stricks	13	43	1069	2	stricks
tacks	11	54	3013	2	t_acks
thack	14	49	1517	2	thack_
thanks	13	43	1313	2	thanks
thicken	16	31	787	2	thicken
thickens	17	26	641	2	thickens
thicker	16	36	1102	2	thicker
thickest	17	33	730	2	thickest
thicket	16	32	1307	2	thicket
thickets	17	28	708	2	thickets
thickish	20	4	460	2	thickish
thickly	19	41	557	2	thickly
thickset	17	25	713	2	thickset
thighs	13	4	663	2	thighs
thills	9	55	1538	2	thills
things	10	49	1430	2	things
think	12	50	1880	2	think_
thins	8	58	2633	2	thi_ns
thiols	9	51	1276	2	thiols
thirds	10	43	860	2	thirds
thirls	9	50	1206	2	thirls
this	7	60	2738	2	thi__s
thunks	13	45	903	2	thunks
thwacks	19	5	361	2	thwacks
tick	10	62	3123	2	t_ick_
tics	6	57	2964	2	t_ic_s
tracks	12	48	1884	2	tracks
trices	8	48	2633	2	trices
trick	11	54	2069	2	trick_
tricksy	16	43	658	2	tricksy
tricky	15	42	1147	2	tricky
trocks	12	36	1463	2	trocks
trucks	12	47	1197	2	trucks
tucks	11	47	2112	2	t_ucks
whacks	18	46	1048	2	whacks
whisks	16	49	735	2	whisks
wicks	14	46	1936	2	_wicks
wricks	15	46	1062	2	wricks
yoicks	15	37	593	2	yoicks

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	82551	0.373	479064.3
2	DLD Change Limit	82551	88	2.626	31436.0
3	Display Results	88	88	0.013	6769.2
	(SQL Overall)	178691	88	3.012	59326.4