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

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

72 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
clocking	17	43	1241	(None)
blocking	17	45	1057	1	blocking
chocking	20	40	1101	1	chocking
clacking	17	33	1349	1	clacking
clicking	17	36	1098	1	clicking
cloaking	15	29	971	1	cloaking
clonking	15	38	1015	1	clonking
clucking	17	42	999	1	clucking
cocking	16	36	1998	1	c_ocking
crocking	17	43	1344	1	crocking
flocking	18	34	1087	1	flocking
locking	14	37	1815	1	_locking
blacking	17	42	1360	2	blacking
checking	20	37	920	2	checking
choking	17	39	1194	2	cho_king
chucking	20	37	950	2	chucking
clanking	15	43	1306	2	clanking
cleeking	15	26	781	2	cleeking
clerking	15	25	716	2	clerking
clinking	15	36	1166	2	clinking
clogging	13	36	850	2	clogging
clomping	15	32	965	2	clomping
cloning	10	32	1547	2	clo_ning
clopping	15	35	1108	2	clopping
closing	10	31	1484	2	clo_sing
clothing	14	27	878	2	clothing
clotting	11	31	1064	2	clotting
clouding	12	26	949	2	clouding
clouring	11	28	1127	2	clouring
clouting	11	30	1168	2	clouting
clowning	14	30	725	2	clowning
cloying	13	35	1175	2	clo_ying
clunking	15	32	943	2	clunking
cockling	17	23	1039	2	c_ockling
coking	13	45	2388	2	c_o_king
conking	14	36	1845	2	c_onking
cooking	14	38	1897	2	c_ooking
corking	14	30	1882	2	c_orking
cracking	17	40	1390	2	cracking
cricking	17	34	1265	2	cricking
croaking	15	37	1216	2	croaking
crooking	15	36	1134	2	crooking
docking	15	36	1501	2	_docking
flacking	18	43	1179	2	flacking
flecking	18	40	823	2	flecking
flicking	18	41	1004	2	flicking
floccing	16	30	603	2	floccing
flockings	19	31	434	2	flockings
frocking	18	30	957	2	frocking
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 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	121059	0.376	475242.0
2	DLD Change Limit	121059	72	3.313	36540.6
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	3.719	48048.1