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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

127 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
assignation	12	4	437	(None)
assignations	13	4	416	1	assignations
designation	13	4	748	2	designation
resignation	12	4	747	2	resignation
agnation	9	3	1172	3	a___gnation
alienation	10	4	879	3	a_lienation
aspiration	12	4	999	3	aspi_ration
assentation	11	4	618	3	assentation
assignat	9	4	568	3	assignat___
assignats	10	4	400	3	assignat__s
assimilation	14	5	552	3	assimilation
association	13	4	615	3	association
castigation	14	4	797	3	castig_ation
consignation	15	13	631	3	consignation
designations	14	5	694	3	designations
fascination	16	4	679	3	fasci_nation
indignation	13	4	653	3	indignation
passivation	16	10	474	3	passi_vation
resignations	13	4	688	3	resignations
stagnation	11	4	554	3	_stagnation
abdication	15	4	822	4	abdi_cation
abnegation	13	4	541	4	abneg_ation
abomination	15	4	748	4	abomination
abrogation	13	10	733	4	abrog_ation
abstention	12	5	439	4	absten_tion
activation	15	6	1013	4	acti_vation
admiration	13	4	773	4	admi_ration
adnation	9	3	1078	4	a___dnation
aestivation	14	4	792	4	aestivation
affiliation	17	4	485	4	affiliation
affirmation	19	5	368	4	affirmation
affixation	23	4	439	4	affi_xation
agitation	10	3	1122	4	a_gi_tation
agnations	10	3	1003	4	a___gnations
alienations	11	4	788	4	a_lienations
allegation	11	4	681	4	alleg_ation
alternation	11	4	762	4	alternation
animation	11	3	1368	4	a_ni_mation
antiquation	20	4	742	4	antiquation
arbitration	13	4	647	4	arbitration
arrogation	11	10	744	4	arrog_ation
aspirations	13	4	899	4	aspi_rations
assassination	13	8	200	4	assassination
assentations	12	4	583	4	assentations
assertion	9	4	672	4	ass__ertion
asseveration	15	5	289	4	asseveration
assignable	13	4	306	4	assigna_ble
assigning	11	4	467	4	assign__ing
assignor	9	4	299	4	assign___or
assimilations	15	5	520	4	assimilations
associations	14	4	575	4	associations
assumption	14	8	302	4	ass_umption
astigmatic	15	4	485	4	astigmati_c
astigmatics	16	5	345	4	astigmatics
astigmatism	16	6	322	4	astigmatism
aviation	11	3	1274	4	a_vi__ation
cachinnation	19	7	242	4	cachinnation
calcination	15	4	890	4	calci_nation
cassation	11	9	791	4	cass___ation
castigations	15	4	720	4	castig_ations
cognation	12	3	1075	4	__cognation
consignations	16	10	593	4	consignations
denigration	13	4	846	4	denigration
desiccation	16	4	638	4	desiccation
designating	14	4	607	4	designating
designative	16	5	433	4	designative
designator	12	4	471	4	designat_or
destination	12	4	1384	4	destination
dissipation	14	4	721	4	dissi_pation
divination	14	13	923	4	divi_nation
domination	13	7	1237	4	domi_nation
emigration	13	22	821	4	_emigration
estimation	12	4	1084	4	esti_mation
estivation	13	4	981	4	esti_vation
evagination	15	4	656	4	evagination
exsiccation	22	4	362	4	exsiccation
fasciation	15	4	683	4	fasci__ation
fascinations	17	4	637	4	fasci_nations
fumigation	16	4	562	4	fumig_ation
fustigation	15	4	521	4	fustig_ation
gemination	13	14	1066	4	gemi_nation
hesitation	13	4	963	4	hesi_tation
ignition	9	4	653	4	___ignition
imagination	14	4	719	4	imagination
immigration	16	4	417	4	immigration
indignations	14	4	604	4	indignations
insinuation	11	13	726	4	insinuation
instigation	12	4	924	4	instig_ation
iodination	11	5	998	4	iodi_nation
irrigation	11	4	780	4	irrig_ation
lamination	12	3	1122	4	lami_nation
levigation	14	4	702	4	levig_ation
ligation	9	23	1309	4	__lig_ation
litigation	11	4	817	4	litig_ation
machination	18	10	682	4	machi_nation
margination	14	4	743	4	margi_nation
marination	12	3	1281	4	mari_nation
mastication	15	6	1029	4	masti_cation
migration	12	17	970	4	__migration
mitigation	13	4	864	4	mitig_ation
navigation	14	4	600	4	navig_ation
nomination	12	7	1210	4	nomi_nation
obligation	13	4	678	4	oblig_ation
ordination	11	4	941	4	ordi_nation
origination	12	6	709	4	_origination
oscillation	13	4	550	4	oscillation
ossification	17	11	654	4	ossification
pagination	13	4	899	4	pagi_nation
passivations	17	6	443	4	passi_vations
patination	12	3	1257	4	pati_nation
pinnation	11	3	801	4	__pinnation
preignition	14	5	443	4	preignition
reignition	11	4	489	4	_reignition
remigration	14	22	891	4	remigration
ruination	9	3	1127	4	_rui_nation
rumination	12	4	1083	4	rumi_nation
salivation	13	4	981	4	sali_vation
sanitation	10	4	1204	4	sani_tation
satiation	9	3	1343	4	sati__ation
siltation	9	3	921	4	__siltation
sinuation	9	3	1041	4	__sinuation
situation	9	4	942	4	__situation
stagnations	12	4	490	4	_stagnations
supination	12	4	988	4	_supination
urination	9	3	1217	4	_uri_nation
vaccination	18	4	646	4	vacci_nation
visitation	13	4	859	4	visi_tation

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	148819	0.420	425454.8
2	DLD Change Limit	148819	127	8.503	17501.9
3	Display Results	127	127	0.076	1671.1
	(SQL Overall)	178691	127	8.999	19856.8