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

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

75 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
formalin	13	4	731	(None)
formalins	14	4	721	1	formalins
formal	11	32	1520	2	formal__
formalise	14	23	978	2	formalise
formalism	16	21	818	2	formalism
formalist	14	19	1064	2	formalist
formality	17	4	699	2	formality
formalize	23	27	1003	2	formalize
formally	16	3	824	2	formally
formals	12	33	1289	2	formal_s
formation	14	3	942	2	formation
bromelin	12	4	634	3	bromelin
complin	13	3	1207	3	co_mplin
coumarin	12	4	732	3	coumarin
domain	9	5	1132	3	do_ma_in
dormin	9	3	1231	3	dorm__in
firman	11	22	1134	3	firma__n
foaling	11	35	1584	3	fo__aling
foeman	11	3	1123	3	foema__n
folacin	12	3	805	3	fo_lacin
foraging	13	5	806	3	for_aging
foramen	12	3	1053	3	for_amen
foramina	13	4	616	3	for_amina
foraying	15	3	743	3	for_aying
foreman	12	3	1236	3	forema__n
foreskin	15	4	702	3	foreskin
formable	15	3	950	3	formable
formably	18	4	666	3	formably
formalised	16	26	666	3	formalised
formalises	15	25	899	3	formalises
formalising	17	5	486	3	formalising
formalisms	17	22	724	3	formalisms
formalists	15	21	762	3	formalists
formalized	25	26	893	3	formalized
formalizer	24	25	787	3	formalizer
formalizes	24	27	1007	3	formalizes
formalizing	26	4	664	3	formalizing
formamide	17	4	440	3	formamide
formant	12	34	1600	3	forma_nt
formants	13	26	995	3	formants
format	11	30	2135	3	forma__t
formate	12	31	1509	3	forma_te
formates	13	28	1429	3	formates
formations	15	3	820	3	formations
formative	17	4	796	3	formative
formats	12	31	1357	3	forma_ts
formatting	16	4	416	3	formatting
formic	13	3	1045	3	form__ic
forming	13	36	1573	3	form__ing
formol	11	29	1033	3	formol__
formols	12	29	941	3	formol_s
formula	12	4	629	3	formul_a
formulae	13	4	598	3	formulae
formulaic	16	5	250	3	formulaic
formulas	13	4	630	3	formulas
formulism	16	21	442	3	formulism
formulist	14	20	591	3	formulist
formulize	23	26	562	3	formulize
formyl	14	27	644	3	formyl__
formyls	15	23	570	3	formyl_s
forsaken	15	4	335	3	forsaken
forsaking	17	4	517	3	forsaking
fortalice	14	4	577	3	fortalice
mortmain	12	4	457	3	mortma_in
normal	8	32	1353	3	normal__
normalcy	15	4	338	3	normalcy
normalise	11	25	942	3	normalise
normality	14	4	720	3	normality
normalize	20	30	1010	3	normalize
normally	13	4	788	3	normally
normals	9	25	1090	3	normal_s
oorali	6	3	1126	3	oor_ali_
ooralis	7	3	1255	3	oor_alis
ordain	7	8	1040	3	_orda_in
tourmaline	12	4	350	3	tourmaline

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	146162	0.420	425454.8
2	DLD Change Limit	146162	75	7.203	20291.8
3	Display Results	75	75	0.033	2272.7
	(SQL Overall)	178691	75	7.656	23340.0