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

Here are the results of your fuzzy-string dictionary search for “formatted” with Change Limit: [1] [2] [3] [4]

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
formatted	15	4	488	(None)
formatter	14	4	546	1	formatter
formate	12	31	1509	2	forma_te_
formates	13	28	1429	2	forma_tes
formatters	15	4	457	2	formatters
reformatted	17	5	262	2	reformatted
borated	10	41	1636	3	bor_a_ted
bromated	13	3	917	3	broma_ted
combatted	16	4	465	3	combatted
committed	16	4	572	3	committed
corotated	12	28	1005	3	corotated
deratted	10	4	840	3	der_atted
dratted	9	35	859	3	_dr_atted
fatted	10	54	1984	3	f___atted
fermate	12	28	1300	3	ferma_te_
fermented	15	4	662	3	fermented
flatted	11	40	1294	3	f__latted
floreated	13	4	657	3	florea_ted
floriated	13	4	702	3	floria_ted
foliated	12	4	991	3	folia_ted
fomented	14	3	780	3	fo_mented
foraged	12	48	1228	3	for_a_ged
forayed	14	36	859	3	for_a_yed
forearmed	15	4	486	3	forearmed
forecasted	16	8	510	3	forecasted
foredated	14	4	768	3	foredated
forested	12	3	1246	3	for_ested
foretasted	14	8	475	3	foretasted
forfeited	16	4	379	3	forfeited
forgather	16	4	366	3	forgather
forgetter	13	4	537	3	forgetter
forgotten	13	4	210	3	forgotten
formable	15	3	950	3	formable_
formalised	16	26	666	3	formalised
formalized	25	26	893	3	formalized
formamide	17	4	440	3	formamide
formant	12	34	1600	3	formant__
formants	13	26	995	3	formant_s
format	11	30	2135	3	forma_t__
formation	14	3	942	3	formation
formative	17	4	796	3	formative
formatives	18	4	621	3	formatives
formats	12	31	1357	3	forma_t_s
formatting	16	4	416	3	formatting
formed	12	50	2117	3	form___ed
formulated	16	4	556	3	formulated
forwarded	17	4	394	3	forwarded
foveated	15	3	629	3	fovea_ted
fracted	13	3	937	3	f_r_acted
fretted	11	34	1185	3	f_r_etted
fritted	11	36	1133	3	f_r_itted
furcated	14	3	759	3	furca_ted
matted	9	45	2141	3	___matted
mordanted	13	4	441	3	mordanted
omitted	10	34	789	3	_o_mitted
orated	7	42	2150	3	_or_a_ted
permitted	14	4	665	3	permitted
preformatted	20	5	227	3	~~pre~~formatted
ratted	7	49	2334	3	__r_atted
tomcatted	14	4	206	3	tomcatted
tormented	12	4	596	3	tormented
unmatted	11	3	829	3	_unmatted

Search took 8 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	148641	0.423	422437.4
2	DLD Change Limit	148641	62	6.890	21573.4
3	Display Results	62	62	0.030	2066.7
	(SQL Overall)	178691	62	7.343	24334.9