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

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

84 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
finicky	19	4	371	(None)
finnicky	20	4	221	1	finnicky
finical	12	3	969	2	finical
finickin	17	7	363	2	finickin
panicky	18	3	385	2	panicky
picnicky	21	4	217	2	picnicky
zincky	24	40	496	2	zin_cky
bricky	17	48	909	3	_bricky
colicky	18	3	578	3	colicky
dicky	15	48	1624	3	__dicky
dinky	13	58	1937	3	din__ky
fancify	18	3	498	3	fancify
fancily	15	3	825	3	fancily
fancy	13	46	1548	3	fan_c_y
fickly	18	31	853	3	f__ickly
finally	13	3	1010	3	finally
finback	18	6	582	3	finback_
finbacks	19	6	536	3	finbacks
finca	10	47	1450	3	fin_c_a
fincas	11	35	1207	3	fin_cas
finch	13	54	1697	3	fin_c_h
finely	12	30	1156	3	fin_ely
finery	12	45	1289	3	fin_ery
finial	9	28	1418	3	fini_al
finials	10	32	1015	3	finials
finically	17	4	795	3	finically
finickier	18	4	262	3	finickier
finicking	19	5	446	3	finicking
finikin	14	26	686	3	finikin
fining	10	42	2321	3	fini_ng
finings	11	43	1177	3	finings
finis	8	68	2426	3	fini__s
finises	10	3	1290	3	finises
finish	12	46	1341	3	fini_sh
finite	9	3	1682	3	fini_te
finitely	14	4	566	3	finitely
finites	10	3	1592	3	finites
finito	9	3	1030	3	fini_to
fink	11	75	3212	3	fin__k_
finks	12	54	2422	3	fin__ks
finlike	14	27	906	3	finlike
finny	11	47	1675	3	fin__ny
fitchy	17	43	762	3	fi_tchy
fixity	19	42	780	3	fixi_ty
flecky	18	38	765	3	f_lecky
flick	14	50	1721	3	f_lick_
flicks	15	45	1299	3	f_licks
flocky	18	46	842	3	f_locky
frisky	16	40	667	3	f_risky
frolicky	20	4	230	3	frolicky
funicle	12	23	748	3	funicle
funky	15	43	1513	3	fun__ky
gimmicky	22	4	166	3	gimmicky
hinky	15	56	1875	3	hin__ky
icky	13	63	1575	3	___icky
inky	11	53	2158	3	_in__ky
kicky	13	50	1233	3	__kicky
kinky	11	58	1638	3	kin__ky
linky	12	76	2238	3	lin__ky
mimicry	16	4	349	3	mimicry
mincy	12	58	1741	3	min_c_y
minicab	13	17	717	3	minicab
minicam	13	11	1006	3	minicam
minicar	11	10	932	3	minicar
minify	14	3	925	3	mini_fy
miniski	13	4	448	3	miniski
nick	10	66	2760	3	__nick_
nicks	11	49	2049	3	__nicks
nitpicky	19	5	169	3	nitpicky
picky	16	54	1694	3	__picky
pinky	14	58	2340	3	pin__ky
pricky	17	42	1034	3	_pricky
shticky	19	34	447	3	shticky
snick	11	44	1601	3	_snick_
snicks	12	43	1247	3	_snicks
sticky	15	47	1134	3	_sticky
tinily	9	40	1443	3	tini_ly
tricky	15	42	1147	3	_tricky
vinic	10	3	1497	3	vinic__
vinify	15	3	692	3	vini_fy
wincey	14	41	1038	3	win_cey
zincify	24	4	391	3	zincify
zincy	19	54	1351	3	zin_c_y
zinky	21	53	1481	3	zin__ky

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	134027	0.406	440125.6
2	DLD Change Limit	134027	84	5.830	22989.2
3	Display Results	84	84	0.030	2800.0
	(SQL Overall)	178691	84	6.266	28517.6