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

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

55 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
disclamation	17	5	424	(None)
disclamations	18	5	372	1	disclamations
declamation	16	4	610	2	d_eclamation
acclamation	17	14	475	3	_acclamation
declamations	17	4	530	3	d_eclamations
declaration	14	4	783	3	d_eclaration
desquamation	24	7	212	3	desquamation
dilatation	11	4	739	3	di__latation
discoloration	16	12	472	3	discoloration
dislocation	14	14	750	3	dis_location
exclamation	22	10	463	3	_exclamation
proclamation	18	5	341	3	proclamation
reclamation	15	4	635	3	_reclamation
acclamations	18	16	404	4	_acclamations
acclimation	17	12	709	4	_acclimation
clavation	14	4	700	4	___clavation
decimation	15	4	1162	4	d_ec_imation
declarations	15	4	680	4	d_eclarations
declination	14	4	1187	4	d_eclination
defamation	16	4	684	4	d__efamation
desalination	13	4	1113	4	desalination
desolation	11	3	1140	4	desol__ation
desquamations	25	8	175	4	desquamations
dictation	12	8	1056	4	di_c__tation
dieselization	23	5	605	4	dieselization
dilatations	12	4	641	4	di__latations
dilation	9	22	1546	4	di__l__ation
discolorations	17	10	430	4	discolorations
discretion	13	4	752	4	disc__retion
discrimination	19	5	535	4	discrimination
disinclination	17	6	396	4	disinclination
disinflation	16	5	658	4	disinflation
dislocations	15	13	698	4	dis_locations
dispensation	15	5	560	4	dispensation
disputation	14	11	674	4	dis_putation
disrelation	12	4	881	4	dis_relation
dissertation	13	6	609	4	dissertation
dissipation	14	4	721	4	dis_sipation
dissociation	15	5	664	4	dissociation
distillation	13	4	774	4	distillation
distraction	14	4	911	4	distra_ction
divagation	15	10	437	4	di__vagation
escalation	12	4	887	4	_esc_alation
exclamations	23	10	410	4	_exclamations
inclination	13	4	973	4	_inclination
inflammation	19	13	288	4	_inflammation
isolation	9	3	1164	4	_isol__ation
miscaption	16	4	476	4	misc_a_ption
miscitation	15	4	777	4	misc_itation
miscreation	15	4	772	4	misc_reation
mislocation	15	12	641	4	mis_location
proclamations	19	5	269	4	proclamations
reclamations	16	4	571	4	_reclamations
scalation	11	3	1107	4	__sc_alation
squamation	21	5	353	4	__squamation

Search took 8 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	124790	0.376	475242.0
2	DLD Change Limit	124790	55	6.780	18405.6
3	Display Results	55	55	0.033	1666.7
	(SQL Overall)	178691	55	7.189	24856.2