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

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

90 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
rachet	11	50	2897	(None)
brachet	14	40	2031	1	brachet
cachet	13	45	2641	1	cachet
rachets	12	45	1683	1	rachets
racket	12	52	2942	1	racket
ratchet	12	42	1833	1	ratchet
rochet	11	54	2300	1	rochet
sachet	11	47	2577	1	sachet
ache	9	68	2982	2	_ache_
ached	11	92	2783	2	_ached
aches	10	61	3229	2	_aches
arched	12	57	1732	2	arched
archer	11	50	1624	2	archer
arches	11	48	2204	2	arches
bached	14	55	1989	2	bached
baches	13	54	2694	2	baches
braches	14	46	2122	2	braches
brachets	15	43	1198	2	brachets
bracket	15	41	1723	2	bracket
cache	12	51	2248	2	cache_
cached	14	54	1920	2	cached
caches	13	79	2691	2	caches
cachets	14	50	1426	2	cachets
crochet	14	36	1666	2	crochet
facet	10	60	3852	2	fac_et
hatchet	15	33	1756	2	hatchet
jacket	19	47	2067	2	jacket
laches	11	65	2834	2	laches
latchet	12	31	1790	2	latchet
mache	12	59	2530	2	mache_
maches	13	48	2723	2	maches
machete	14	3	1088	2	machete
manchet	14	33	1777	2	manchet
naches	11	46	2241	2	naches
orache	11	40	1359	2	orache_
oraches	12	42	1647	2	oraches
packet	14	47	2650	2	packet
rabbet	10	38	1865	2	rabbet
race	6	67	4626	2	rac_e_
raced	8	76	3531	2	rac_ed
racer	7	52	3302	2	rac_er
races	7	49	4324	2	rac_es
racheted	14	14	950	2	racheted
rachis	11	40	1765	2	rachis
racier	8	51	2097	2	racier
raciest	9	28	2001	2	raciest
racist	8	28	2279	2	racist
racked	13	45	2608	2	racked
racker	12	48	2455	2	racker
rackets	13	49	1687	2	rackets
rackety	16	49	911	2	rackety
racquet	18	3	874	2	racquet
ramet	7	57	4314	2	ra_met
ramjet	15	3	1154	2	ramjet
ranched	13	31	1360	2	ranched
rancher	12	30	1363	2	rancher
ranches	12	36	2011	2	ranches
raphe	10	49	1642	2	raphe_
raphes	11	51	1745	2	raphes
rasher	9	50	2411	2	rasher
rashes	9	53	3015	2	rashes
rashest	10	39	1687	2	rashest
ratches	12	36	2046	2	ratches
ratchets	13	31	1026	2	ratchets
rathe	8	58	2192	2	rathe_
rather	9	43	1973	2	rather
reached	13	46	1908	2	reached
reacher	12	37	1829	2	reacher
reaches	12	34	2320	2	reaches
recheat	12	4	1593	2	recheat
rechew	14	3	1021	2	rechew
richen	11	38	1251	2	richen
richer	11	40	1504	2	richer
riches	11	50	2208	2	riches
richest	12	28	1368	2	richest
roached	13	32	1183	2	roached
roaches	12	36	1621	2	roaches
rochets	12	42	1347	2	rochets
rocket	12	54	2528	2	rocket
ruche	10	42	1676	2	ruche_
ruched	12	43	1463	2	ruched
ruches	11	48	1958	2	ruches
sachem	13	40	1222	2	sachem
sachets	12	39	1410	2	sachets
tacet	7	58	4002	2	tac_et
tache	10	62	2237	2	tache_
taches	11	42	2417	2	taches
tacket	12	46	2749	2	tacket
trachea	12	3	1167	2	trachea
yacht	13	4	1739	2	yach_t

Search took 3 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	82551	0.126	1418182.5
2	DLD Change Limit	82551	90	2.750	30018.5
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	2.906	61490.4