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

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

64 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
sanctifications	22	5	413	(None)
sanctification	21	5	470	1	sanctification_
acetifications	21	4	605	3	_acetifications
calcifications	20	4	541	3	calc_ifications
dandifications	21	4	543	3	dan_difications
fructifications	25	11	335	3	fructifications
notifications	18	4	823	3	__notifications
pacifications	22	6	735	3	pa_c_ifications
pontifications	21	8	792	3	pon_tifications
quantifications	29	11	440	3	quan_tifications
ratifications	18	9	978	3	ra__tifications
rectifications	21	4	891	3	_rectifications
saponifications	22	13	332	3	saponifications
specifications	23	4	535	3	spec_ifications
stratifications	20	5	423	3	stratifications
stultifications	20	8	353	3	stultifications
acetification	20	4	672	4	_acetification_
acidifications	22	5	463	4	_acidifications
amplifications	23	8	475	4	_amplifications
anticipations	17	5	749	4	_an_ticipations
basifications	20	13	706	4	ba__sifications
beatifications	21	15	746	4	_beatifications
beautifications	22	15	468	4	beautifications
calcification	19	4	582	4	calc_ification_
caprifications	23	8	556	4	ca_prifications
certifications	21	4	779	4	_certifications
citifications	20	4	854	4	__citifications
dandification	20	4	590	4	dan_dification_
denazifications	30	16	408	4	denazifications
densifications	20	4	698	4	den_sifications
falsifications	22	4	497	4	fa_lsifications
fortifications	22	8	621	4	_fortifications
fructification	24	8	367	4	fructification_
gasifications	19	11	684	4	ga__sifications
gentrifications	21	7	504	4	gentrifications
gratifications	20	4	598	4	_gratifications
identifications	21	5	449	4	identifications
justifications	26	4	555	4	_justifications
magnifications	22	4	511	4	ma_gnifications
mortifications	21	8	650	4	_mortifications
mystifications	24	4	564	4	_mystifications
nazifications	27	4	552	4	__nazifications
nidifications	19	4	694	4	__nidifications
nitrifications	19	8	663	4	__nitrifications
notification	17	4	906	4	__notification_
pacification	21	6	805	4	pa_c_ification_
pontification	20	8	901	4	pon_tification_
prettifications	22	13	518	4	prettifications
quantification	28	12	493	4	quan_tification_
ramifications	20	8	753	4	ra__mifications
ratification	17	8	1066	4	ra__tification_
rectification	20	4	951	4	_rectification_
sanitizations	22	4	855	4	san__itizations
saponification	21	10	353	4	saponification_
scarifications	21	5	576	4	s_carifications
significations	20	12	567	4	s_ignifications
silicifications	22	5	307	4	silicifications
simplifications	24	6	319	4	simplifications
solidifications	21	5	357	4	solidifications
specification	22	4	576	4	spec_ification_
stratification	19	5	467	4	stratification_
stultification	19	6	390	4	stultification_
unifications	17	4	804	4	_un__ifications
vinifications	21	7	769	4	vin__ifications

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	43548	0.280	638182.1
2	DLD Change Limit	43548	64	2.236	19475.8
3	Display Results	64	64	0.046	1391.3
	(SQL Overall)	178691	64	2.562	69746.7