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

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

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.

72 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
pancreatins	15	5	384	(None)
pancreatin	14	5	423	1	pancreatin_
pancreatic	16	5	397	2	pancreati_c
pancreatitis	16	6	188	2	pancreatitis
creatins	10	36	1751	3	___creatins
pancratia	13	4	465	3	pancr_ati_a
pancratic	15	4	636	3	pancr_ati_c
pancratium	16	5	302	3	pancr_atium
pancratiums	17	6	210	3	pancr_atiums
pancreas	12	3	539	3	pancrea___s
pancreases	14	4	376	3	pancrea_ses
procreating	16	4	769	3	procreating
procreations	16	4	727	3	procreations
uncreating	13	3	1047	3	_uncreating
accreting	14	4	633	4	_accre_ting
accretions	14	4	492	4	_accre_tions
acetins	9	3	1317	4	_a_c_e_tins
acrasins	10	3	997	4	_a_cr_asins
anorectics	14	4	451	4	_anorectics
anoretics	11	4	864	4	_anore_tics
ascertains	12	4	426	4	_ascertains
cancelations	16	5	709	4	cancelations
ceratins	10	28	1873	4	___ceratins
cocreating	15	3	1029	4	_cocreating
concreting	15	3	987	4	concre_ting
concretions	15	4	929	4	concre_tions
creatin	9	36	1813	4	___creatin_
creatine	10	34	1741	4	___creatine
creatines	11	28	1443	4	___creatines
creating	11	39	2195	4	___creating
creations	11	26	1454	4	___creations
cretins	9	32	1642	4	___cre_tins
entreaties	10	4	811	4	_entreaties
entreating	11	8	1155	4	_entreating
increasing	13	4	632	4	_increasing
incretions	12	4	865	4	_incre_tions
intreating	11	6	1401	4	_intreating
lacerating	13	4	945	4	la_cerating
lacerations	13	4	833	4	la_cerations
lancinating	14	4	545	4	lancinating
laureating	11	4	639	4	la_ureating
laureations	11	4	557	4	la_ureations
macerating	15	4	954	4	ma_cerating
macerations	15	4	847	4	ma_cerations
maltreating	14	5	551	4	maltreating
miscreating	16	4	849	4	miscreating
miscreations	16	4	706	4	miscreations
noncreative	16	4	823	4	noncreative
packeting	18	3	685	4	pa_cke_ting
pancaking	18	3	638	4	panc__aking
pancettas	13	4	399	4	panc_e_ttas
pancreatitides	19	6	94	4	pancreatitides
pancreozymins	31	7	61	4	pancreozymins
parenting	12	6	1158	4	pa__renting
parentings	13	5	561	4	pa__rentings
paretics	12	23	1244	4	pa__re_tics
patriating	13	5	1020	4	pa_triating
precreasing	16	4	570	4	precreasing
pretreating	14	4	889	4	pretreating
procreates	14	4	815	4	procreat_es
procreation	15	4	795	4	procreation
procreative	18	4	631	4	procreative
procreators	15	7	571	4	procreators
punctations	15	8	535	4	punc_tations
punctuating	16	4	310	4	punctuating
punctuations	16	4	318	4	punctuations
recreating	13	12	1458	4	_recreating
recreations	13	4	1225	4	_recreations
secretins	11	10	846	4	_secre_tins
uncrating	12	8	1318	4	_uncr_ating
uncreates	11	3	1043	4	_uncreat_es
uncreative	15	4	753	4	_uncreative

Search took 10 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	148819	0.420	425454.8
2	DLD Change Limit	148819	72	9.266	16060.8
3	Display Results	72	72	0.046	1565.2
	(SQL Overall)	178691	72	9.732	18361.2