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

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

69 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
thicker	16	36	1102	(None)
shicker	16	39	1482	1	shicker
thicken	16	31	787	1	thicken
thicket	16	32	1307	1	thicket
thinker	14	36	1068	1	thinker
ticker	12	43	2150	1	t_icker
tricker	13	46	1552	1	tricker
whicker	19	35	977	1	whicker
bicker	14	48	1917	2	_bicker
checker	18	32	953	2	checker
chicer	13	45	1360	2	chic_er
chickee	18	31	1155	2	chickee
chicken	18	27	898	2	chicken
chirker	16	42	932	2	chirker
clicker	15	41	1188	2	clicker
dicker	13	45	2140	2	_dicker
flicker	16	36	1062	2	flicker
hacker	15	48	2269	2	_hacker
hickey	18	50	1199	2	_hickey
hiker	12	51	1939	2	_hi_ker
hocker	15	51	1856	2	_hocker
icker	11	40	1844	2	__icker
kicker	11	41	1618	2	_kicker
licker	12	52	2204	2	_licker
nicker	12	38	1870	2	_nicker
picker	14	44	2217	2	_picker
pricker	15	40	1341	2	pricker
quicker	22	4	702	2	quicker
shickers	17	30	1282	2	shickers
shikker	13	27	702	2	shikker
shirker	14	37	1134	2	shirker
shocker	16	34	1143	2	shocker
shucker	16	37	1010	2	shucker
sicker	12	40	2390	2	_sicker
slicker	13	33	1453	2	slicker
snicker	13	30	1267	2	snicker
sticker	13	35	1588	2	sticker
tacker	12	42	2450	2	t_acker
thacked	17	38	1020	2	thacked
thanker	14	30	959	2	thanker
thick	14	56	1335	2	thick__
thickener	18	4	416	2	thickener
thickens	17	26	641	2	thickens
thickest	17	33	730	2	thickest
thickets	17	28	708	2	thickets
thickety	20	27	410	2	thickety
thickly	19	41	557	2	thickly
thicks	15	45	1199	2	thick_s
thickset	17	25	713	2	thickset
thinkers	15	30	870	2	thinkers
thinner	10	35	898	2	thinner
thither	13	32	810	2	thither
thwacker	20	4	287	2	thwacker
ticked	13	47	2052	2	t_icked
tickers	13	36	1772	2	t_ickers
ticket	12	45	2485	2	t_icket
tickler	13	36	1265	2	t_ickler
tinker	10	36	1992	2	t_inker
tracker	13	35	1517	2	tracker
tricked	14	40	1616	2	tricked
trickers	14	38	1281	2	trickers
trickery	17	29	734	2	trickery
trickier	14	30	1023	2	trickier
trucker	13	40	1073	2	trucker
tucker	12	43	1695	2	t_ucker
whacker	19	36	850	2	whacker
whickers	20	29	798	2	whickers
whisker	17	36	793	2	whisker
wicker	15	45	1867	2	_wicker

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	107671	0.373	479064.3
2	DLD Change Limit	107671	69	2.940	36622.8
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	3.343	53452.3