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

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

73 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
assassination	13	8	200	(None)
assassinations	13	10	204	1	assassinations
assassinating	14	6	145	2	assassinating
assassinator	12	6	136	2	assassinat_or
assassinate	11	6	195	3	assassinat__e
assassinated	13	6	155	3	assassinat_ed
assassinates	11	6	168	3	assassinat_es
assassinators	12	6	128	3	assassinators
assignation	12	4	437	4	a_s_signation
assimilation	14	5	552	4	ass_imilation
association	13	4	615	4	ass_oci_ation
desalination	13	4	1112	4	desa_lination
fascination	16	4	678	4	__fascination
passivation	16	10	474	4	__passivation
abomination	15	4	748	5	a__bomination
aestivation	14	4	792	5	a__estivation
agglutination	15	11	265	5	agglutination
asphyxiation	27	6	138	5	asphyxi_ation
aspiration	12	4	999	5	___aspiration
assassin	8	4	407	5	assass____i_n
assassins	8	4	392	5	assassin____s
assentation	11	4	617	5	a_s_sentation
asseveration	15	5	289	5	ass_everation
assignations	13	4	415	5	a_s_signations
assimilations	15	5	520	5	ass_imilations
associations	14	4	574	5	ass_oci_ations
bastardization	26	14	307	5	bastardization
calcination	15	4	890	5	__calcination
cassation	11	9	791	5	__cass__ation
castigation	14	4	797	5	__castigation
deamination	14	4	1154	5	_dea_mination
delamination	15	4	885	5	dela_mination
deracination	15	4	886	5	dera_cination
desalinations	14	4	1017	5	desa_linations
destination	12	4	1383	5	__destination
disassociation	17	6	328	5	disassociation
dissemination	16	5	577	5	dissemination
dissipation	14	4	719	5	__dissipation
emargination	15	5	486	5	_emargination
evagination	15	4	656	5	_eva_gination
examination	20	5	845	5	_exa_mination
exsanguination	22	6	159	5	exsanguination
fantastication	19	6	223	5	fantastication
fasciation	15	4	683	5	__fasci_ation
fascinations	17	4	635	5	__fascinations
imagination	14	4	719	5	_ima_gination
incardination	16	5	503	5	incardination
insanitation	12	12	718	5	insa_nitation
insemination	14	4	698	5	ins_emination
invagination	16	4	564	5	inva_gination
lamination	12	3	1122	5	__la_mination
machination	18	10	682	5	__machination
margination	14	4	743	5	__margination
marination	12	3	1281	5	__ma_rination
mastication	15	6	1029	5	__mastication
misassumption	19	6	150	5	misassumption
misestimation	17	9	471	5	misestimation
nasalization	21	4	937	5	nasa_lization
necessitation	15	12	309	5	necessitation
ossification	17	11	654	5	oss_ification
pagination	13	4	899	5	__pa_gination
passivations	17	6	443	5	__passivations
patination	12	3	1257	5	__pa_tination
resuscitation	15	5	429	5	resuscitation
revaccination	20	5	386	5	revaccination
salivation	13	4	981	5	__sa_livation
sanitation	10	4	1204	5	__sa_nitation
satiation	9	3	1342	5	__sa_ti_ation
stagnation	11	4	554	5	_sta__gnation
supination	12	4	988	5	__s_upination
suspiration	13	4	654	5	__suspiration
transamination	16	10	379	5	transa_mination
vaccination	18	4	645	5	__vaccination

Search took 10 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.156	1145455.1
2	DLD Change Limit	124790	73	9.093	13723.7
3	Display Results	73	73	0.046	1587.0
	(SQL Overall)	178691	73	9.295	19224.4