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

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

62 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
fracted	13	3	937	(None)
bracted	12	4	1093	1	bracted
acted	8	85	2173	2	__acted
braced	11	54	2060	2	brac_ed
coacted	12	36	1161	2	coacted
cracked	16	35	1474	2	cracked
crafted	13	41	977	2	crafted
crated	9	48	2777	2	cra_ted
drafted	12	43	903	2	drafted
dratted	9	35	859	2	dratted
enacted	10	3	1064	2	enacted
erected	10	32	1399	2	erected
eructed	10	22	865	2	eructed
exacted	17	3	730	2	exacted
faced	11	77	2765	2	f_ac_ed
faceted	13	50	956	2	f_aceted
farced	12	52	1653	2	farc_ed
farted	10	51	2178	2	f_arted
fasted	10	53	2095	2	f_asted
fated	9	56	3213	2	f_a_ted
fatted	10	54	1984	2	f_atted
feasted	11	3	1084	2	feasted
flacked	17	37	1158	2	flacked
flatted	11	40	1294	2	flatted
fractal	12	3	762	2	fractal
fracti	11	3	996	2	fract_i
fractur	12	13	557	2	fractur
fractured	15	12	506	2	fractured
fractus	12	14	659	2	fractus
fragged	13	40	1016	2	fragged
framed	12	51	1652	2	fra_med
franked	15	36	1005	2	franked
frapped	15	31	885	2	frapped
frater	9	45	2059	2	fra_ter
frayed	13	50	1216	2	fra_yed
fretted	11	34	1185	2	fretted
fritted	11	36	1133	2	fritted
frocked	17	43	933	2	frocked
fronted	11	40	1127	2	fronted
frosted	11	32	1187	2	frosted
fruited	11	38	909	2	fruited
furcated	14	3	759	2	furcated
graced	10	52	1790	2	grac_ed
grafted	12	41	1022	2	grafted
granted	9	47	1510	2	granted
grated	8	45	2392	2	gra_ted
infracted	15	4	636	2	infracted
orated	7	42	2150	2	ora_ted
prated	9	49	2492	2	pra_ted
preacted	13	27	1094	2	preacted
raced	8	76	3531	2	_rac_ed
racked	13	45	2608	2	_racked
rafted	10	47	1470	2	_rafted
ranted	7	43	2470	2	_ranted
rated	6	54	4138	2	_ra_ted
ratted	7	49	2334	2	_ratted
reacted	10	30	1571	2	reacted
refracted	15	5	739	2	refracted
traced	9	48	2158	2	trac_ed
tracked	14	37	1613	2	tracked
unacted	10	3	1273	2	unacted
wracked	17	41	1011	2	wracked

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	62	3.503	30736.8
3	Display Results	62	62	0.013	4769.2
	(SQL Overall)	178691	62	3.889	45947.8