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

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

61 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
sockets	13	40	1298	(None)
dockets	14	44	1224	1	dockets
lockets	13	46	1220	1	lockets
pockets	15	46	1225	1	pockets
rockets	13	46	1536	1	rockets
socket	12	39	2352	1	socket_
beckets	15	39	982	2	beckets
boskets	13	40	947	2	boskets
brockets	16	32	812	2	brockets
buckets	15	38	1169	2	buckets
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
lockers	13	35	1692	2	lockers
locket	12	39	2247	2	locket_
locksets	14	3	569	2	locksets
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
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_
sachets	12	39	1410	2	sachets
sackers	13	38	2022	2	sackers
secrets	9	3	1177	2	secrets
shockers	17	31	946	2	shockers
sickees	13	45	1421	2	sickees
sickens	13	44	1148	2	sickens
sickest	13	18	1379	2	sickest
soakers	11	41	1495	2	soakers
soccers	11	3	839	2	soccers
society	12	3	608	2	society
socked	13	47	2150	2	socke_d
socketed	15	17	734	2	socketed
sockeye	16	6	641	2	sockeye
sockeyes	17	6	576	2	sockeyes
sockless	14	26	779	2	sockless
socks	11	49	2608	2	sock__s
socles	8	4	1845	2	socle_s
sokes	9	50	3142	2	so_ke_s
sonnets	7	42	1199	2	sonnets
sorbets	9	30	1250	2	sorbets
soviets	10	8	729	2	soviets
sprockets	17	4	325	2	sprockets
stockers	14	34	1107	2	stockers
suckers	13	37	1762	2	suckers
sunkets	11	35	1128	2	sunkets
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 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	107671	0.143	1249587.4
2	DLD Change Limit	107671	61	3.906	27565.5
3	Display Results	61	61	0.030	2033.3
	(SQL Overall)	178691	61	4.079	43807.6