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

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

80 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
rackets	13	49	1687	(None)
brackets	16	33	1043	1	brackets
jackets	20	50	1137	1	jackets
packets	15	51	1477	1	packets
rachets	12	45	1683	1	rachets
rackers	13	43	2045	1	rackers
racket	12	52	2942	1	racket_
rackety	16	49	911	1	rackety
rickets	13	49	1509	1	rickets
rockets	13	46	1536	1	rockets
tackets	13	49	1436	1	tackets
ackees	12	49	1458	2	_ackees
backers	15	38	2188	2	backers
backsets	16	3	885	2	backsets
baskets	13	51	1183	2	baskets
beckets	15	39	982	2	beckets
brachets	15	43	1198	2	brachets
brackens	16	32	792	2	brackens
bracket	15	41	1723	2	bracket_
brockets	16	32	812	2	brockets
buckets	15	38	1169	2	buckets
cachets	14	50	1426	2	cachets
caskets	13	39	1017	2	caskets
crackers	16	41	1172	2	crackers
crickets	16	41	812	2	crickets
crockets	16	33	954	2	crockets
dackers	14	34	1704	2	dackers
dockets	14	44	1224	2	dockets
facets	11	63	1665	2	fac_ets
gaskets	12	34	815	2	gaskets
hackees	16	50	1410	2	hackees
hackers	16	46	1904	2	hackers
jackers	20	42	1445	2	jackers
jacket	19	47	2067	2	jacket_
lackers	13	41	2054	2	lackers
lackeys	16	45	826	2	lackeys
lockets	13	46	1220	2	lockets
markets	13	33	1403	2	markets
packers	15	38	1889	2	packers
packet	14	47	2650	2	packet_
pickets	15	43	1418	2	pickets
plackets	16	4	658	2	plackets
pockets	15	46	1225	2	pockets
prickets	16	32	908	2	prickets
rabbets	11	27	942	2	rabbets
racers	8	47	2543	2	rac_ers
races	7	49	4324	2	rac_e_s
rachet	11	50	2897	2	rachet_
raciest	9	28	2001	2	raciest
racists	9	26	1332	2	racists
racked	13	45	2608	2	racke_d
racker	12	48	2455	2	racke_r
racketed	15	16	912	2	racketed
racks	11	50	2885	2	rack__s
racquets	19	4	476	2	racquets
rakees	10	45	1697	2	ra_kees
rakers	10	41	2357	2	ra_kers
rakes	9	44	4035	2	ra_ke_s
ramets	8	35	1739	2	ra_mets
ramjets	16	3	516	2	ramjets
rankers	11	32	1746	2	rankers
rankest	11	27	1381	2	rankest
ratchets	13	31	1026	2	ratchets
rejackets	22	6	298	2	rejackets
rickety	16	47	831	2	rickety
rickeys	16	54	898	2	rickeys
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
sockets	13	40	1298	2	sockets
tackers	13	43	1962	2	tackers
tacket	12	46	2749	2	tacket_
tickets	13	41	1368	2	tickets
trackers	14	35	1285	2	trackers
tuckets	13	48	1033	2	tuckets
wackes	15	47	1771	2	wacke_s
wackest	16	47	1086	2	wackest
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.376	475242.0
2	DLD Change Limit	107671	80	3.330	32333.6
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.736	47829.5