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

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

58 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
flecking	18	40	823	(None)
flacking	18	43	1179	1	flacking
flicking	18	41	1004	1	flicking
flocking	18	34	1087	1	flocking
becking	16	44	1607	2	_becking
beflecking	22	4	303	2	beflecking
blacking	17	42	1360	2	blacking
blocking	17	45	1057	2	blocking
checking	20	37	920	2	checking
clacking	17	33	1349	2	clacking
cleeking	15	26	781	2	cleeking
clerking	15	25	716	2	clerking
clicking	17	36	1098	2	clicking
clocking	17	43	1241	2	clocking
clucking	17	42	999	2	clucking
decking	15	39	1559	2	_decking
electing	11	21	1378	2	electing
flaking	15	41	1449	2	fl_aking
flanking	16	42	1108	2	flanking
fledging	14	27	652	2	fledging
fleeching	18	30	501	2	fleeching
fleecing	14	34	757	2	fleecing
fleeing	11	35	1129	2	fle_eing
fleering	12	38	1128	2	fleering
fleeting	12	29	1032	2	fleeting
flenching	18	29	670	2	flenching
flensing	12	4	697	2	flensing
fleshing	15	33	930	2	fleshing
fletching	18	25	614	2	fletching
flexing	18	35	899	2	fle_xing
fleying	14	32	987	2	fle_ying
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
freaking	16	36	1145	2	freaking
freckling	19	3	470	2	freckling
frocking	18	30	957	2	frocking
fucking	17	32	1228	2	f_ucking
gecking	15	41	1136	2	_gecking
gleeking	14	31	649	2	gleeking
kecking	13	41	1188	2	_kecking
lacking	14	38	2154	2	_lacking
leaking	12	36	1697	2	_leaking
leching	13	46	1365	2	_leching
lekking	11	30	650	2	_lekking
licking	14	41	1828	2	_licking
locking	14	37	1815	2	_locking
lucking	14	36	1583	2	_lucking
necking	14	39	1389	2	_necking
pecking	16	40	1778	2	_pecking
plucking	17	35	772	2	plucking
recking	14	43	1992	2	_recking
slacking	15	39	1413	2	slacking
sleeking	13	34	1096	2	sleeking
slicking	15	37	1259	2	slicking
specking	17	35	973	2	specking
wrecking	18	32	815	2	wrecking

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.390	458182.1
2	DLD Change Limit	121059	58	3.576	33853.2
3	Display Results	58	58	0.016	3625.0
	(SQL Overall)	178691	58	3.982	44874.7