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

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

54 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
lockets	13	46	1220	(None)
dockets	14	44	1224	1	dockets
lockers	13	35	1692	1	lockers
locket	12	39	2247	1	locket_
locksets	14	3	569	1	locksets
pockets	15	46	1225	1	pockets
rockets	13	46	1536	1	rockets
sockets	13	40	1298	1	sockets
beckets	15	39	982	2	beckets
blockers	16	39	879	2	blockers
boskets	13	40	947	2	boskets
brockets	16	32	812	2	brockets
buckets	15	38	1169	2	buckets
clockers	16	36	981	2	clockers
cockers	15	36	1833	2	cockers
crockets	16	33	954	2	crockets
dockers	14	37	1500	2	dockers
docket	13	47	2117	2	docket_
hockers	16	39	1591	2	hockers
hockeys	19	50	927	2	hockeys
jackets	20	50	1137	2	jackets
jockeys	23	36	595	2	jockeys
lackers	13	41	2054	2	lackers
lackeys	16	45	826	2	lackeys
lickers	13	41	1825	2	lickers
locates	9	32	1881	2	locates
locked	13	49	2166	2	locke_d
locker	12	40	1942	2	locke_r
locknuts	14	4	368	2	locknuts
lockouts	14	4	549	2	lockouts
locks	11	51	2692	2	lock__s
lockset	13	3	1116	2	lockset_
lockups	15	3	424	2	lockups
locoes	8	55	1658	2	locoe_s
locusts	9	27	793	2	locusts
loggets	9	37	891	2	loggets
lookers	11	40	1407	2	lookers
mockers	15	38	1294	2	mockers
ockers	12	38	1390	2	_ockers
octets	8	3	940	2	_octets
packets	15	51	1477	2	packets
pickets	15	43	1418	2	pickets
plackets	16	4	658	2	plackets
pocket	14	46	2262	2	pocket_
rackets	13	49	1687	2	rackets
rickets	13	49	1509	2	rickets
rochets	12	42	1347	2	rochets
rockers	13	39	1655	2	rockers
rocket	12	54	2528	2	rocket_
socket	12	39	2352	2	socket_
tackets	13	49	1436	2	tackets
tickets	13	41	1368	2	tickets
tuckets	13	48	1033	2	tuckets
wickets	16	40	1094	2	wickets

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.373	479064.3
2	DLD Change Limit	107671	54	3.046	35348.3
3	Display Results	54	54	0.033	1636.4
	(SQL Overall)	178691	54	3.452	51764.5