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

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

65 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
prettifications	22	13	518	(None)
prettification	21	11	571	1	prettification_
petrifications	21	4	802	2	p_etrifications
rectifications	21	4	891	2	_rectifications
acetifications	21	4	605	3	ace_tifications
beatifications	21	15	746	3	_beatifications
certifications	21	4	779	3	_certifications
fructifications	25	11	335	3	fructifications
gratifications	20	4	598	3	gr_atifications
identifications	21	5	449	3	identifications
petrification	20	4	881	3	p_etrification_
pontifications	21	8	791	3	p_ontifications
prenotification	22	5	360	3	prenotification_
preunification	21	5	430	3	preunification_
ratifications	18	9	978	3	_r_atifications
rectification	20	4	951	3	_rectification_
reifications	17	4	1182	3	_re__ifications
reunifications	19	13	691	3	_reunifications
acetification	20	4	672	4	ace_tification_
beatification	20	13	807	4	_beatification_
beautifications	22	15	468	4	beautifications
certification	20	4	860	4	_certification_
citifications	20	4	854	4	__citifications
deifications	18	4	1065	4	_de__ifications
densifications	20	4	698	4	_densifications
detoxifications	28	8	425	4	_detoxifications
edifications	18	4	869	4	__e_difications
esterifications	20	13	481	4	esterifications
fortifications	22	8	621	4	_fortifications
fructification	24	8	367	4	fructification_
gentrifications	21	7	504	4	gentrifications
gratification	19	4	668	4	gr_atification_
identification	20	5	499	4	identification_
justifications	26	4	555	4	_justifications
lithifications	22	13	479	4	_lithifications
mortifications	21	8	650	4	_mortifications
mystifications	24	4	564	4	_mystifications
nitrifications	19	8	663	4	_nitrifications
notifications	18	4	823	4	__notifications
pacifications	22	6	735	4	p__acifications
petrifactions	20	8	356	4	p_etrifac_tions
pontification	20	8	900	4	p_ontification_
precipitations	20	8	539	4	pre_cipitations
predications	17	4	1118	4	pre___dications
prefabrications	24	9	243	4	prefabrications
premodification	25	8	297	4	premodification_
prepublications	23	7	266	4	prepublications
preterminations	19	5	430	4	preterminations
prevarications	21	5	474	4	pre_varications
purifications	20	4	746	4	p__urifications
quantifications	29	11	440	4	quantifications
ramifications	20	8	753	4	_r_amifications
ratification	17	8	1066	4	_r_atification_
recodifications	23	16	545	4	_recodifications
reification	16	4	1290	4	_re__ification_
reunification	18	14	745	4	_reunification_
reutilizations	23	4	871	4	_reutilizations
revivifications	26	9	405	4	_revivifications
sanctifications	22	5	413	4	sanctifications
specifications	23	4	535	4	spe_cifications
stratifications	20	5	423	4	stratifications
stultifications	20	8	353	4	stultifications
verifications	21	15	997	4	_ve_rifications
versifications	22	16	691	4	_versifications
vitrifications	22	7	596	4	_vitrifications

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.076	2351197.4
2	DLD Change Limit	43548	65	2.266	19218.0
3	Display Results	65	65	0.046	1413.0
	(SQL Overall)	178691	65	2.388	74828.7