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

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

66 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
frocking	18	30	957	(None)
crocking	17	43	1344	1	crocking
flocking	18	34	1087	1	flocking
rocking	14	36	1963	1	_rocking
trocking	15	36	1242	1	trocking
arcking	14	58	1196	2	ar_cking
blocking	17	45	1057	2	blocking
bricking	17	39	1140	2	bricking
broking	14	35	1482	2	bro_king
brooking	15	37	1070	2	brooking
chocking	20	40	1101	2	chocking
clocking	17	43	1241	2	clocking
cocking	16	36	1998	2	_cocking
cracking	17	40	1390	2	cracking
cricking	17	34	1265	2	cricking
croaking	15	37	1216	2	croaking
crooking	15	36	1134	2	crooking
defrocking	21	4	315	2	defrocking
docking	15	36	1501	2	_docking
drouking	14	3	644	2	drouking
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
forcing	13	40	1375	2	forc_ing
forking	15	40	1484	2	f_orking
franking	16	43	1086	2	franking
freaking	16	36	1145	2	freaking
freckling	19	3	470	2	freckling
frisking	16	26	836	2	frisking
frogging	14	35	873	2	frogging
frolicking	20	4	281	2	frolicking
fronting	12	3	1044	2	fronting
frosting	12	3	1118	2	frosting
frothing	15	20	853	2	frothing
frowning	15	30	783	2	frowning
fucking	17	32	1228	2	f_ucking
grokking	13	3	481	2	grokking
hocking	17	34	1724	2	_hocking
knocking	14	24	594	2	knocking
locking	14	37	1815	2	_locking
mocking	16	36	1445	2	_mocking
nocking	14	36	1511	2	_nocking
pocking	16	39	1676	2	_pocking
pricking	17	32	1260	2	pricking
racking	14	43	2366	2	_racking
recking	14	43	1992	2	_recking
ricking	14	39	2023	2	_ricking
rockling	15	25	938	2	_rockling
rooking	12	35	1736	2	_rooking
rucking	14	32	1667	2	_rucking
shocking	18	43	1154	2	shocking
smocking	17	34	910	2	smocking
socking	14	35	1860	2	_socking
stocking	15	29	1250	2	stocking
tracking	15	37	1546	2	tracking
tricking	15	27	1451	2	tricking
troaking	13	33	1097	2	troaking
troking	12	35	1410	2	tro_king
trucking	15	33	1016	2	trucking
unfrocking	20	4	353	2	unfrocking
wracking	18	34	996	2	wracking
wrecking	18	32	815	2	wrecking
wricking	18	34	949	2	wricking
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.406	440125.6
2	DLD Change Limit	121059	66	3.673	32959.2
3	Display Results	66	66	0.030	2200.0
	(SQL Overall)	178691	66	4.109	43487.7