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

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

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	1	identifications_
identification	20	5	499	2	identification__
densifications	20	4	698	3	_densifications_
acetifications	21	4	605	4	ace_tifications_
beatifications	21	15	746	4	_beatifications_
certifications	21	4	779	4	_certifications_
dandifications	21	4	543	4	_dandifications_
deifications	18	4	1065	4	_de__ifications_
denazifications	30	16	408	4	_denazifications_
densification	19	4	733	4	_densification__
gentrifications	21	7	504	4	_gentrifications_
pontifications	21	8	792	4	_pontifications_
prettifications	22	13	518	4	prettifications_
quantifications	29	11	440	4	quantifications_
rectifications	21	4	891	4	_rectifications_
acetification	20	4	672	5	ace_tification__
beatification	20	13	807	5	_beatification__
beautifications	22	15	468	5	beautifications_
certification	20	4	860	5	_certification__
citifications	20	4	854	5	__citifications_
cornifications	21	4	595	5	corn_ifications_
dandification	20	4	590	5	_dandification__
deification	17	4	1166	5	_de__ification__
denazification	29	15	443	5	_denazification__
denitrification	21	18	387	5	_denitrification__
denticulations	17	5	391	5	_denticulations_
detoxications	23	5	565	5	_de_toxications_
detoxifications	28	8	425	5	_detoxifications_
edifications	18	4	869	5	__e_difications_
fortifications	22	8	621	5	_fortifications_
fructifications	25	11	335	5	fructifications_
gentrification	20	6	563	5	_gentrification__
gratifications	20	4	598	5	_gratifications_
indemnification	23	7	200	5	indemnification__
intensification	20	9	276	5	intensification__
intimidations	16	8	666	5	i__ntimidations_
intoxications	22	13	568	5	i__ntoxications_
justifications	26	4	555	5	_justifications_
lignifications	20	13	511	5	lign_ifications_
magnifications	22	4	511	5	magn_ifications_
mortifications	21	8	650	5	_mortifications_
mystifications	24	4	564	5	_mystifications_
nidifications	19	4	694	5	nid___ifications_
notifications	18	4	823	5	__notifications_
petrifications	21	4	802	5	_petrifications_
pontification	20	8	901	5	_pontification__
prenotification	22	5	360	5	prenotification__
prettification	21	11	571	5	prettification__
quantification	28	12	493	5	quantification__
ratifications	18	9	978	5	__ratifications_
rectification	20	4	951	5	_rectification__
reifications	17	4	1182	5	_re__ifications_
reunifications	19	13	691	5	_reunifications_
sanctifications	22	5	413	5	sanctifications_
significations	20	12	567	5	sign_ifications_
specifications	23	4	535	5	spe_cifications_
stratifications	20	5	423	5	stratifications_
stultifications	20	8	353	5	stultifications_
unifications	17	4	804	5	__un_ifications_
verifications	21	15	997	5	_ve_rifications_
versifications	22	16	691	5	_versifications_
vinifications	21	7	769	5	_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.296	603685.8
2	DLD Change Limit	43548	62	2.516	17308.4
3	Display Results	62	62	0.046	1347.8
	(SQL Overall)	178691	62	2.858	62523.1