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

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

124 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
assignations	13	4	416	(None)
assignation	12	4	437	1	assignation_
designations	14	5	694	2	designations
resignations	13	4	688	2	resignations
agnations	10	3	1003	3	a___gnations
alienations	11	4	788	3	a_lienations
aspirations	13	4	899	3	aspi_rations
assentations	12	4	583	3	assentations
assignats	10	4	400	3	assignat___s
assimilations	15	5	520	3	assimilations
associations	14	4	575	3	associations
castigations	15	4	720	3	castig_ations
consignations	16	10	593	3	consignations
designation	13	4	748	3	designation_
fascinations	17	4	637	3	fasci_nations
indignations	14	4	604	3	indignations
passivations	17	6	443	3	passi_vations
resignation	12	4	747	3	resignation_
stagnations	12	4	490	3	_stagnations
abdications	16	5	765	4	abdi_cations
abnegations	14	4	492	4	abneg_ations
abominations	16	4	661	4	abominations
abrogations	14	11	646	4	abrog_ations
abstentions	13	6	436	4	absten_tions
activations	16	6	926	4	acti_vations
admirations	14	4	669	4	admi_rations
adnations	10	3	975	4	a___dnations
aestivations	15	4	748	4	aestivations
affiliations	18	4	418	4	affiliations
affirmations	20	5	323	4	affirmations
affixations	24	4	385	4	affi_xations
agitations	11	3	1006	4	a_gi_tations
agnation	9	3	1172	4	a___gnation_
alienation	10	4	879	4	a_lienation_
allegations	12	4	604	4	alleg_ations
alternations	12	4	677	4	alternations
animations	12	3	1219	4	a_ni_mations
antiquations	21	4	624	4	antiquations
arbitrations	14	4	576	4	arbitrations
arrogations	12	12	648	4	arrog_ations
aspiration	12	4	999	4	aspi_ration_
assassinations	13	10	204	4	assassinations
assentation	11	4	618	4	assentation_
assertions	10	4	658	4	ass__ertions
asseverations	16	5	259	4	asseverations
assignat	9	4	568	4	assignat____
assigning	11	4	467	4	assign__i_ng
assignors	10	4	324	4	assign___ors
assimilation	14	5	552	4	assimilation_
association	13	4	615	4	association_
assumptions	15	6	273	4	ass_umptions
astigmatics	16	5	345	4	astigmati_cs
astigmatisms	17	7	264	4	astigmatisms
aviations	12	3	1155	4	a_vi__ations
cachinnations	20	9	212	4	cachinnations
calcinations	16	4	793	4	calci_nations
cassations	12	7	687	4	cass___ations
castigation	14	4	797	4	castig_ation_
cognations	13	3	959	4	__cognations
consignation	15	13	631	4	consignation_
denigrations	14	4	735	4	denigrations
desiccations	17	5	565	4	desiccations
designating	14	4	607	4	designati_ng
designators	13	4	430	4	designat_ors
destinations	13	4	1266	4	destinations
dissipations	15	4	653	4	dissi_pations
divinations	15	12	841	4	divi_nations
dominations	14	6	1104	4	domi_nations
emigrations	14	18	715	4	_emigrations
estimations	13	4	994	4	esti_mations
estivations	14	4	927	4	esti_vations
evaginations	16	4	582	4	evaginations
exsiccations	23	4	326	4	exsiccations
fasciations	16	4	626	4	fasci__ations
fascination	16	4	679	4	fasci_nation_
fumigations	17	4	492	4	fumig_ations
fustigations	16	4	476	4	fustig_ations
geminations	14	13	926	4	gemi_nations
hesitations	14	4	854	4	hesi_tations
ignitions	10	4	580	4	___ignitions
imaginations	15	4	634	4	imaginations
immigrations	17	4	372	4	immigrations
indignation	13	4	653	4	indignation_
insinuations	12	13	642	4	insinuations
instigations	13	4	824	4	instig_ations
iodinations	12	6	884	4	iodi_nations
irrigations	12	4	694	4	irrig_ations
laminations	13	3	980	4	lami_nations
levigations	15	4	621	4	levig_ations
ligations	10	21	1199	4	__lig_ations
litigations	12	4	733	4	litig_ations
machinations	19	11	576	4	machi_nations
marginations	15	4	645	4	margi_nations
marinations	13	4	1127	4	mari_nations
mastications	16	4	941	4	masti_cations
migrations	13	16	868	4	__migrations
mitigations	14	4	762	4	mitig_ations
navigations	15	4	520	4	navig_ations
nominations	13	4	1053	4	nomi_nations
obligations	14	4	614	4	oblig_ations
ordinations	12	4	799	4	ordi_nations
originations	13	10	618	4	_originations
oscillations	14	4	512	4	oscillations
ossifications	18	17	614	4	ossifications
paginations	14	4	775	4	pagi_nations
passivation	16	10	474	4	passi_vation_
patinations	13	4	1100	4	pati_nations
pinnations	12	3	688	4	__pinnations
preignitions	15	5	400	4	preignitions
reignitions	12	4	455	4	_reignitions
remigrations	15	22	779	4	remigrations
ruinations	10	3	960	4	_rui_nations
ruminations	13	4	939	4	rumi_nations
salivations	14	4	873	4	sali_vations
sanitations	11	4	1084	4	sani_tations
satiations	10	3	1211	4	sati__ations
siltations	10	3	855	4	__siltations
sinuations	10	3	941	4	__sinuations
situations	10	3	843	4	__situations
stagnation	11	4	554	4	_stagnation_
supinations	13	4	883	4	_supinations
urinations	10	3	1069	4	_uri_nations
vaccinations	19	4	568	4	vacci_nations
visitations	14	4	767	4	visi_tations

Search took 9 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.783	228213.3
2	DLD Change Limit	124790	124	7.233	17252.9
3	Display Results	124	124	0.080	1550.0
	(SQL Overall)	178691	124	8.096	22071.5