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

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

63 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
flicking	18	41	1004	(None)
clicking	17	36	1098	1	clicking
flacking	18	43	1179	1	flacking
flecking	18	40	823	1	flecking
flocking	18	34	1087	1	flocking
licking	14	41	1828	1	_licking
slicking	15	37	1259	1	slicking
blacking	17	42	1360	2	blacking
blinking	15	35	1062	2	blinking
blocking	17	45	1057	2	blocking
bricking	17	39	1140	2	bricking
clacking	17	33	1349	2	clacking
clinking	15	36	1166	2	clinking
clocking	17	43	1241	2	clocking
clucking	17	42	999	2	clucking
cricking	17	34	1265	2	cricking
dicking	15	36	1761	2	_dicking
filching	17	3	611	2	filching
finicking	19	5	446	2	finicking
finking	15	40	1660	2	f_inking
flaking	15	41	1449	2	fl_aking
flanking	16	42	1108	2	flanking
flickering	20	4	409	2	flickering
flinching	18	24	583	2	flinching
flinging	13	33	1005	2	flinging
flinting	12	34	1234	2	flinting
flipping	16	30	766	2	flipping
flirting	12	31	901	2	flirting
flitching	18	26	534	2	flitching
fliting	11	35	1461	2	fli_ting
flitting	12	30	1088	2	flitting
floccing	16	30	603	2	floccing
flockings	19	31	434	2	flockings
fluking	15	44	1051	2	fl_uking
flunking	16	31	777	2	flunking
frisking	16	26	836	2	frisking
frocking	18	30	957	2	frocking
frolicking	20	4	281	2	frolicking
fucking	17	32	1228	2	f_ucking
hoicking	18	3	605	2	hoicking
kicking	13	33	1402	2	_kicking
lacking	14	38	2154	2	_lacking
lickings	15	29	814	2	_lickings
liking	11	43	1958	2	_li_king
linking	12	38	1825	2	_linking
locking	14	37	1815	2	_locking
lucking	14	36	1583	2	_lucking
nicking	14	35	1632	2	_nicking
picking	16	34	1833	2	_picking
plinking	15	36	1124	2	plinking
plucking	17	35	772	2	plucking
pricking	17	32	1260	2	pricking
ricking	14	39	2023	2	_ricking
sicking	14	37	2017	2	_sicking
slacking	15	39	1413	2	slacking
slicing	10	35	1464	2	slic_ing
slinking	13	34	1298	2	slinking
snicking	15	36	1023	2	snicking
sticking	15	35	1346	2	sticking
ticking	14	32	1875	2	_ticking
tricking	15	27	1451	2	tricking
wicking	17	34	1477	2	_wicking
wricking	18	34	949	2	wricking

Search took 5 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	121059	0.410	435831.7
2	DLD Change Limit	121059	63	3.843	31501.2
3	Display Results	63	63	0.013	4846.2
	(SQL Overall)	178691	63	4.266	41887.2