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

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

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
identifications	21	5	449	(None)
identification	20	5	499	1	identification_
densifications	20	4	698	2	_densifications
acetifications	21	4	605	3	ace_tifications
beatifications	21	15	746	3	_beatifications
certifications	21	4	779	3	_certifications
dandifications	21	4	543	3	_dandifications
deifications	18	4	1065	3	_de__ifications
denazifications	30	16	408	3	_denazifications
densification	19	4	733	3	_densification_
gentrifications	21	7	504	3	_gentrifications
pontifications	21	8	791	3	_pontifications
prettifications	22	13	518	3	prettifications
quantifications	29	11	440	3	quantifications
rectifications	21	4	891	3	_rectifications
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
cornifications	21	4	595	4	corn_ifications
dandification	20	4	590	4	_dandification_
deification	17	4	1166	4	_de__ification_
denazification	29	15	443	4	_denazification_
denitrification	21	18	387	4	_denitrification_
denticulations	17	5	391	4	_denticulations
detoxications	23	5	565	4	_de_toxications
detoxifications	28	8	425	4	_detoxifications
edifications	18	4	869	4	__e_difications
fortifications	22	8	621	4	_fortifications
fructifications	25	11	335	4	fructifications
gentrification	20	6	563	4	_gentrification_
gratifications	20	4	598	4	_gratifications
indemnification	23	7	200	4	indemnification_
intensification	20	9	276	4	intensification_
intimidations	16	8	666	4	i__ntimidations
intoxications	22	13	568	4	i__ntoxications
justifications	26	4	555	4	_justifications
lignifications	20	13	511	4	lign_ifications
magnifications	22	4	511	4	magn_ifications
mortifications	21	8	650	4	_mortifications
mystifications	24	4	564	4	_mystifications
nidifications	19	4	694	4	nid___ifications
notifications	18	4	823	4	__notifications
petrifications	21	4	802	4	_petrifications
pontification	20	8	900	4	_pontification_
prenotification	22	5	360	4	prenotification_
prettification	21	11	571	4	prettification_
quantification	28	12	493	4	quantification_
ratifications	18	9	978	4	__ratifications
rectification	20	4	951	4	_rectification_
reifications	17	4	1182	4	_re__ifications
reunifications	19	13	691	4	_reunifications
sanctifications	22	5	413	4	sanctifications
significations	20	12	567	4	sign_ifications
specifications	23	4	535	4	spe_cifications
stratifications	20	5	423	4	stratifications
stultifications	20	8	353	4	stultifications
unifications	17	4	804	4	__un_ifications
verifications	21	15	997	4	_ve_rifications
versifications	22	16	691	4	_versifications
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	62	1.986	21927.5
3	Display Results	62	62	0.046	1347.8
	(SQL Overall)	178691	62	2.312	77288.5