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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

151 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
thickens	17	26	641	(None)
chickens	19	26	743	1	chickens
thicken	16	31	787	1	thicken_
thickets	17	28	708	1	thickets
chickees	19	25	851	2	chickees
chicken	18	27	898	2	chicken_
dickens	14	44	1013	2	_dickens
hickeys	19	50	822	2	_hickeys
quickens	23	3	425	2	quickens
shickers	17	30	1282	2	shickers
sickens	13	44	1148	2	_sickens
slickens	14	31	726	2	slickens
thickened	19	4	430	2	thickened
thickener	18	4	416	2	thickener
thickeners	19	4	346	2	thickeners
thicker	16	36	1102	2	thicke_r
thickest	17	33	730	2	thickest
thicket	16	32	1307	2	thicke_t
thickety	20	27	410	2	thickety
thickness	18	4	444	2	thickness
thicks	15	45	1199	2	thick__s
thicksets	18	26	373	2	thicksets
thinkers	15	30	869	2	thinkers
tickers	13	36	1772	2	t_ickers
tickets	13	41	1368	2	t_ickets
trickers	14	38	1281	2	trickers
whickers	20	29	798	2	whickers
bickers	15	43	1655	3	_bickers
blackens	16	38	810	3	blackens
brackens	16	32	792	3	brackens
checkers	19	31	784	3	checkers
chicanes	15	5	937	3	chicanes
chickee	18	31	1155	3	chicke_e
chickened	21	4	462	3	chickened
chickpeas	22	4	295	3	chickpeas
chicks	17	53	1759	3	chick__s
chicles	14	35	1250	3	chicle_s
chicness	15	3	559	3	chicness
clickers	16	39	1020	3	clickers
crickets	16	41	812	3	crickets
dickers	14	41	1766	3	_dickers
dickeys	17	47	930	3	_dickeys
ethicians	14	4	528	3	ethicians
flickers	17	33	888	3	flickers
hackees	16	50	1410	3	_hackees
hackers	16	46	1904	3	_hackers
harkens	14	41	1286	3	_harkens
hickey	18	50	1199	3	_hicke_y
hickies	16	36	1474	3	_hickies
hicks	14	53	2217	3	_hick__s
hikers	13	50	1435	3	_hi_kers
hikes	12	54	2698	3	_hi_ke_s
hockers	16	39	1591	3	_hockers
hockeys	19	50	927	3	_hockeys
ickers	12	39	1418	3	__ickers
kickers	12	40	1329	3	_kickers
knickers	13	30	672	3	knickers
lichens	12	35	1068	3	_lichens
lickers	13	41	1825	3	_lickers
likens	10	56	1370	3	_li_kens
mickeys	18	44	794	3	_mickeys
nickels	13	33	865	3	_nickels
nickers	13	44	1509	3	_nickers
pickers	15	37	1809	3	_pickers
pickets	15	43	1418	3	_pickets
pinkens	13	41	964	3	_pinkens
prickers	16	37	1067	3	prickers
prickets	16	32	908	3	prickets
quicken	22	3	515	3	quicken_
richens	12	34	973	3	_richens
rickets	13	49	1509	3	_rickets
rickeys	16	54	898	3	_rickeys
shicker	16	39	1482	3	shicke_r
shicksas	17	4	352	3	shicksas
shikkers	14	32	652	3	shikkers
shippens	15	31	679	3	shippens
shirkers	15	31	958	3	shirkers
shockers	17	31	946	3	shockers
shuckers	17	38	813	3	shuckers
sickees	13	45	1421	3	_sickees
sicken	12	46	1525	3	_sicken_
slackens	14	36	771	3	slackens
slicken	13	30	929	3	slicken_
slickers	14	31	1255	3	slickers
snickers	14	30	1096	3	snickers
stickers	14	29	1302	3	stickers
stricken	14	3	689	3	stricken_
tackers	13	43	1962	3	t_ackers
tackets	13	49	1436	3	t_ackets
thacked	17	38	1020	3	thacke_d
thacking	18	31	1004	3	thacking
thacks	15	43	1192	3	thack__s
thankers	15	29	783	3	thankers
thens	8	59	2183	3	th___ens
thiamins	13	4	661	3	thiamins
thiazins	20	4	530	3	thiazins
thick	14	56	1335	3	thick___
thickening	20	4	328	3	thickening
thickenings	21	5	168	3	thickenings
thicketed	19	4	361	3	thicketed
thickhead	22	4	268	3	thickhead
thickheads	23	4	248	3	thickheads
thickish	20	4	459	3	thickish
thickly	19	41	557	3	thick_ly
thickset	17	25	713	3	thickset
thieves	13	4	690	3	thieve_s
thinker	14	36	1067	3	thinke_r
thinking	16	28	984	3	thinking
thinkings	17	25	504	3	thinkings
thinks	13	46	1335	3	think__s
thinners	11	32	774	3	thinners
thinness	11	27	715	3	thinness
thins	8	58	2632	3	thi___ns
thionins	11	7	792	3	thionins
thiophens	17	4	344	3	thiophens
thirteens	12	4	300	3	thirteens
thwackers	21	4	222	3	thwackers
ticked	13	47	2052	3	t_icke_d
ticker	12	43	2150	3	t_icke_r
ticket	12	45	2485	3	t_icke_t
ticking	14	32	1875	3	t_icking
tickings	15	36	858	3	t_ickings
ticklers	14	33	930	3	t_icklers
tickles	13	34	1685	3	t_ickles
ticks	11	58	2329	3	t_ick__s
tikes	9	56	2890	3	t_i_ke_s
tinkers	11	35	1714	3	t_inkers
tokens	10	47	1156	3	t__okens
trackers	14	35	1284	3	trackers
triceps	11	26	734	3	tric_eps
trices	8	48	2633	3	tric_e_s
tricked	14	40	1616	3	tricke_d
tricker	13	46	1552	3	tricke_r
trickery	17	29	734	3	trickery
tricking	15	27	1451	3	tricking
trickles	14	30	1376	3	trickles
tricks	12	53	1901	3	trick__s
tricorns	10	3	667	3	tricorns
triens	6	54	1754	3	tri__ens
trikes	10	54	1949	3	tri_ke_s
trinkets	12	3	714	3	trinkets
truckers	14	27	900	3	truckers
tuckers	13	40	1435	3	t_uckers
tuckets	13	48	1033	3	t_uckets
whackers	20	32	654	3	whackers
whicker	19	35	977	3	whicke_r
whiskers	18	30	677	3	whiskers
whiskeys	21	35	338	3	whiskeys
whitens	13	42	873	3	whi_tens
wickers	16	41	1470	3	_wickers
wickets	16	40	1094	3	_wickets

Search took 9 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.173	1032896.0
2	DLD Change Limit	146162	151	7.920	18454.8
3	Display Results	151	151	0.126	1198.4
	(SQL Overall)	178691	151	8.219	21741.2