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

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

59 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
flocking	18	34	1087	(None)
blocking	17	45	1057	1	blocking
clocking	17	43	1241	1	clocking
flacking	18	43	1179	1	flacking
flecking	18	40	823	1	flecking
flicking	18	41	1004	1	flicking
floccing	16	30	603	1	floccing
flockings	19	31	434	1	flockings
frocking	18	30	957	1	frocking
locking	14	37	1815	1	_locking
blacking	17	42	1360	2	blacking
chocking	20	40	1101	2	chocking
clacking	17	33	1349	2	clacking
clicking	17	36	1098	2	clicking
cloaking	15	29	971	2	cloaking
clonking	15	38	1015	2	clonking
clucking	17	42	999	2	clucking
cocking	16	36	1998	2	_cocking
crocking	17	43	1344	2	crocking
docking	15	36	1501	2	_docking
flaking	15	41	1449	2	fl_aking
flanking	16	42	1108	2	flanking
floating	12	31	1188	2	floating
flockier	17	4	534	2	flockier
flogging	14	32	917	2	flogging
flooding	13	23	896	2	flooding
flooring	12	25	988	2	flooring
flopping	16	38	877	2	flopping
flossing	12	24	790	2	flossing
flouring	12	30	1014	2	flouring
flouting	12	26	1047	2	flouting
flowing	14	34	1176	2	flo_wing
fluking	15	44	1051	2	fl_uking
flunking	16	31	777	2	flunking
forking	15	40	1484	2	f_orking
fucking	17	32	1228	2	f_ucking
hocking	17	34	1724	2	_hocking
knocking	14	24	594	2	knocking
lacking	14	38	2154	2	_lacking
licking	14	41	1828	2	_licking
locoing	10	28	1097	2	_locoing
looking	12	34	1504	2	_looking
lucking	14	36	1583	2	_lucking
mocking	16	36	1445	2	_mocking
nocking	14	36	1511	2	_nocking
plonking	15	35	856	2	plonking
plucking	17	35	772	2	plucking
pocking	16	39	1676	2	_pocking
relocking	16	13	768	2	relocking
rocking	14	36	1963	2	_rocking
shocking	18	43	1154	2	shocking
slacking	15	39	1413	2	slacking
slicking	15	37	1259	2	slicking
smocking	17	34	910	2	smocking
socking	14	35	1860	2	_socking
stocking	15	29	1250	2	stocking
trocking	15	36	1242	2	trocking
unlocking	16	3	607	2	unlocking
yocking	17	37	1237	2	_yocking

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	59	3.796	31891.2
3	Display Results	59	59	0.033	1787.9
	(SQL Overall)	178691	59	4.219	42353.9