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

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

32 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
mockery	18	37	691	(None)
mocker	14	33	1544	1	mocker_
mockers	15	38	1294	1	mockers
monkery	16	31	745	1	monkery
rockery	16	43	925	1	rockery
cocker	14	43	2039	2	cocker_
cockers	15	36	1833	2	cockers
cookery	16	42	1039	2	cookery
crockery	19	35	660	2	crockery
docker	13	44	1765	2	docker_
dockers	14	37	1500	2	dockers
hocker	15	51	1856	2	hocker_
hockers	16	39	1591	2	hockers
hockey	18	48	1315	2	hocke_y
jockey	22	40	803	2	jocke_y
locker	12	40	1942	2	locker_
lockers	13	35	1692	2	lockers
mickey	17	42	1185	2	micke_y
mocked	15	47	1661	2	mocke_d
monkey	15	37	1059	2	monke_y
mopery	13	52	1097	2	mo_pery
mothery	15	37	1051	2	mothery
mucker	14	38	1639	2	mucker_
muckers	15	36	1280	2	muckers
ochery	14	31	944	2	_ochery
ocker	11	39	1575	2	_ocker_
ockers	12	38	1390	2	_ockers
puckery	18	30	626	2	puckery
rocker	12	43	1957	2	rocker_
rockers	13	39	1655	2	rockers
rocketry	17	4	450	2	rocketry
rookery	14	39	831	2	rookery

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	107671	0.406	440125.6
2	DLD Change Limit	107671	32	3.376	31893.1
3	Display Results	32	32	0.016	2000.0
	(SQL Overall)	178691	32	3.798	47048.7