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

Here are the results of your fuzzy-string dictionary search for “thickety” with Change Limit: [1] [2] [3] [4]

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.

79 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
thickety	20	27	410	(None)
thicket	16	32	1307	1	thicket_
thickets	17	28	708	1	thickets
hickey	18	50	1199	2	_hicke_y
rickety	16	47	831	2	_rickety
thicken	16	31	787	2	thicke_n
thickens	17	26	641	2	thickens
thicker	16	36	1102	2	thicke_r
thickest	17	33	730	2	thickest
thicketed	19	4	361	2	thicketed
thickly	19	41	557	2	thick_ly
thickset	17	25	713	2	thickset_
thicksets	18	26	373	2	thicksets
ticket	12	45	2485	2	t_icket_
tickets	13	41	1368	2	t_ickets
trickery	17	29	734	2	trickery
chickee	18	31	1155	3	chicke_e
chickees	19	25	851	3	chickees
chicken	18	27	898	3	chicke_n
chickens	19	26	743	3	chickens
chickory	22	4	336	3	chickory
cricket	15	47	1695	3	cricket_
crickets	16	41	812	3	crickets
crickey	18	41	814	3	cricke_y
dickey	16	59	1352	3	_dicke_y
flickery	20	36	510	3	flickery
hickeys	19	50	822	3	_hickeys
hickory	19	4	390	3	_hickory
hockey	18	48	1315	3	_hocke_y
mickey	17	42	1185	3	_micke_y
nicety	11	3	843	3	_nic_ety
picket	14	49	2431	3	_picket_
pickets	15	43	1418	3	_pickets
pricket	15	36	1644	3	pricket_
prickets	16	32	908	3	prickets
rackety	16	49	911	3	_rackety
rickets	13	49	1509	3	_rickets
rickey	15	46	1397	3	_ricke_y
shicker	16	39	1482	3	shicke_r
shickers	17	30	1282	3	shickers
snickery	17	29	554	3	snickery
tacket	12	46	2749	3	t_acket_
tackets	13	49	1436	3	t_ackets
tackey	15	46	1308	3	t_acke_y
thacked	17	38	1020	3	thacke_d
thick	14	56	1335	3	thick___
thickened	19	4	430	3	thickened
thickener	18	4	416	3	thickener
thickhead	22	4	269	3	thickhead
thickish	20	4	460	3	thickish
thickness	18	4	444	3	thickness
thicks	15	45	1199	3	thick__s
thievery	17	4	256	3	thievery
thinker	14	36	1068	3	thinke_r
thinkers	15	30	870	3	thinkers
thirsty	13	5	408	3	thi_rsty
thirty	12	37	840	3	thi__rty
ticked	13	47	2052	3	t_icke_d
ticker	12	43	2150	3	t_icke_r
tickers	13	36	1772	3	t_ickers
ticketed	15	14	664	3	t_icketed
tricked	14	40	1616	3	tricke_d
tricker	13	46	1552	3	tricke_r
trickers	14	38	1281	3	trickers
trickily	17	3	623	3	trickily
trickly	16	36	989	3	trick_ly
tricksy	16	43	658	3	trick_sy
tricky	15	42	1147	3	trick__y
trinket	11	3	1481	3	trinket_
trinketry	16	4	280	3	trinketry
trinkets	12	3	714	3	trinkets
tucket	12	42	1948	3	t_ucket_
tuckets	13	48	1033	3	t_uckets
whicker	19	35	977	3	whicke_r
whickers	20	29	798	3	whickers
whiskery	21	31	455	3	whiskery
whiskey	20	44	558	3	whiske_y
wicket	15	53	1894	3	_wicket_
wickets	16	40	1094	3	_wickets

Search took 7 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	146162	0.423	422437.4
2	DLD Change Limit	146162	79	6.173	23677.6
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	6.626	26968.2