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

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

246 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
designations	14	5	694	(None)
designation	13	4	748	1	designation_
resignations	13	4	688	1	resignations
assignations	13	4	416	2	assignations
denigrations	14	4	735	2	denigrations
desiccations	17	5	565	2	desiccations
designating	14	4	607	2	designati_ng
designators	13	4	430	2	designat_ors
destinations	13	4	1266	2	destinations
resignation	12	4	747	2	resignation_
assignation	12	4	437	3	assignation_
consignations	16	10	593	3	consignations
deaminations	15	10	1013	3	deaminations
decimations	16	4	1016	3	deci_mations
declinations	15	4	1022	3	declinations
dedications	15	3	1087	3	dedi_cations
definitions	15	4	560	3	defi_nitions
delegations	13	4	803	3	deleg_ations
delineations	13	4	676	3	delineations
denegations	13	4	854	3	deneg_ations
denigration	13	4	846	3	denigration_
depilations	14	3	1090	3	depi_lations
derivations	15	6	1149	3	deri_vations
derogations	13	4	939	3	derog_ations
desalinations	14	4	1018	3	desalinations
desecrations	15	5	921	3	desecrations
desiccation	16	4	638	3	desiccation_
desiderations	15	4	567	3	desiderations
designates	12	4	636	3	designat__es
designative	16	5	433	3	designati_ve
designator	12	4	471	3	designat_o_r
designatory	16	5	338	3	designat_ory
desolations	12	3	1059	3	des_olations
desperations	15	5	952	3	desperations
destination	12	4	1384	3	destination_
detonations	12	3	937	3	de_tonations
deviations	14	3	1116	3	devi__ations
divinations	15	12	841	3	divi_nations
dominations	14	6	1104	3	domi_nations
emigrations	14	18	715	3	_emigrations
geminations	14	13	925	3	gemi_nations
hesitations	14	4	854	3	hesi_tations
indignations	14	4	604	3	indignations
levigations	15	4	621	3	levig_ations
reignitions	12	4	455	3	re_ignitions
remigrations	15	22	779	3	remigrations
aestivations	15	4	748	4	aestivations
agnations	10	3	1003	4	___agnations
alienations	11	4	788	4	_alienations
castigations	15	4	720	4	castig_ations
cessations	12	5	647	4	ces__sations
cognations	13	3	959	4	__cognations
consignation	15	13	631	4	consignation_
damnations	13	3	708	4	d__amnations
darnations	11	3	841	4	d__arnations
deaerations	12	3	1167	4	de_aerations
dealations	11	3	1137	4	de__alations
deamination	14	4	1154	4	deamination_
debarkations	19	4	365	4	debarkations
debilitations	16	4	713	4	debilitations
decantations	15	4	794	4	decantations
decimation	15	4	1162	4	deci_mation_
declamations	17	4	530	4	declamations
declarations	15	4	680	4	declarations
declination	14	4	1187	4	declination_
decollations	15	4	736	4	decollations
decorations	14	3	1288	4	de_corations
decussations	15	4	367	4	decussations
dedication	14	3	1196	4	dedi_cation_
defalcations	18	4	519	4	defalcations
defamations	17	4	589	4	de_famations
defecations	17	7	900	4	de_fecations
defibrinations	20	5	341	4	defibrinations
definition	14	4	596	4	defi_nition_
deflagrations	18	8	302	4	deflagrations
deflations	14	3	971	4	de__flations
deflorations	16	4	606	4	deflorations
defoliations	16	4	759	4	defoliations
deformations	18	4	684	4	deformations
degradations	15	4	455	4	degradations
degustations	14	4	483	4	degustations
dehydrations	20	4	340	4	dehydrations
deifications	18	4	1065	4	deifications
deionizations	23	4	921	4	de_ionizations
delaminations	16	4	794	4	delaminations
delations	10	26	1659	4	de___lations
delectations	15	4	745	4	delectations
delegation	12	3	888	4	deleg_ation_
deliberations	16	4	553	4	deliberations
delimitations	16	7	663	4	delimitations
delineation	12	4	776	4	delineation_
demarcations	17	4	612	4	demarcations
denegation	12	4	941	4	deneg_ation_
denervations	16	5	709	4	denervations
denigrating	14	14	692	4	denigrati_ng
denigrators	13	4	452	4	denigrat_ors
denominations	16	11	785	4	denominations
denotations	12	3	985	4	de_notations
densifications	20	4	698	4	densifications
dentations	11	4	1363	4	de__ntations
denudations	13	4	634	4	de_nudations
deoxidations	21	4	524	4	deoxidations
deoxygenations	26	6	174	4	deoxygenations
depictions	15	4	689	4	depi__ctions
depigmentations	21	10	284	4	depigmentations
depilation	13	3	1203	4	depi_lation_
deportations	15	4	846	4	deportations
depravations	18	8	537	4	depravations
deprecations	17	4	856	4	deprecations
depredations	16	4	673	4	depredations
deprivations	18	9	792	4	deprivations
deputations	14	4	834	4	de_putations
deracinations	16	4	783	4	deracinations
deregulations	15	4	520	4	deregulations
derivation	14	7	1278	4	deri_vation_
derogation	12	4	1039	4	derog_ation_
desalination	13	4	1113	4	desalination_
descensions	14	4	437	4	descen_sions
descriptions	17	5	540	4	descriptions
desecration	14	4	1007	4	desecration_
desegregations	17	6	356	4	desegregations
desertions	11	3	988	4	des__ertions
desiccating	17	4	470	4	desiccati_ng
desiccators	16	4	380	4	desiccat_ors
desideration	14	5	639	4	desideration_
designate	11	4	711	4	designat___e
designated	13	4	593	4	designat__ed
designing	12	3	662	4	design__i_ng
designings	13	4	262	4	design__ings
desolation	11	3	1140	4	des_olation_
desorptions	14	4	599	4	des_orptions
desperation	14	5	1011	4	desperation_
despoliations	16	4	639	4	despoliations
desquamations	25	8	175	4	desquamations
destitutions	13	8	525	4	destitutions
destructions	15	4	725	4	destructions
detentions	11	14	880	4	de_ten_tions
detestations	13	4	758	4	detestations
detonation	11	3	1094	4	de_tonation_
deuterations	13	4	808	4	deuterations
devaluations	16	4	635	4	devaluations
devastations	16	4	582	4	devastations
deviation	13	3	1239	4	devi__ation_
dictations	13	8	970	4	d__ictations
digestions	12	4	640	4	d__igestions
dilations	10	26	1445	4	d__i_lations
diminutions	14	4	454	4	dimi_nutions
disfunctions	18	5	452	4	disfunctions
disinflations	17	5	629	4	disinflations
disjunctions	22	5	407	4	disjunctions
dislocations	15	13	698	4	dislocations
dispensations	16	5	548	4	dispensations
disputations	15	10	617	4	disputations
disrelations	13	4	850	4	disrelations
dissentions	12	16	804	4	dissen_tions
dissipations	15	4	653	4	dissipations
distentions	12	17	884	4	disten_tions
distillations	14	4	694	4	distillations
distinctions	15	5	732	4	distinctions
divagations	16	10	383	4	divag_ations
divination	14	13	923	4	divi_nation_
domination	13	7	1237	4	domi_nation_
donations	10	11	1235	4	d___onations
dubitations	14	5	667	4	dubi_tations
dysfunctions	21	5	213	4	dysfunctions
eliminations	14	4	761	4	_eliminations
elongations	12	4	466	4	_elongations
emanations	12	8	959	4	_e_manations
emigration	13	22	821	4	_emigration_
enations	8	33	1690	4	_e___nations
epilations	12	3	1171	4	_epi_lations
escalations	13	4	766	4	_escalations
estimations	13	4	994	4	_estimations
estivations	14	4	927	4	_estivations
etiolations	11	4	739	4	_etiolations
evaginations	16	4	582	4	_evaginations
exsiccations	23	4	326	4	exsiccations
fascinations	17	4	637	4	fascinations
fumigations	17	4	492	4	fumig_ations
fustigations	16	4	476	4	fustig_ations
gemination	13	14	1065	4	gemi_nation_
germinations	15	13	794	4	germinations
gestations	11	3	977	4	ges__tations
hesitation	13	4	963	4	hesi_tation_
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
legations	10	27	1192	4	le__g_ations
legislations	13	4	375	4	legislations
levigation	14	4	702	4	levig_ation_
levitations	14	4	829	4	levi_tations
ligations	10	21	1199	4	__lig_ations
litigations	12	4	733	4	litig_ations
marginations	15	4	645	4	marginations
marinations	13	4	1127	4	mari_nations
mediations	13	3	1098	4	medi__ations
medications	16	4	993	4	medi_cations
meditations	14	4	933	4	medi_tations
meliorations	14	6	675	4	meliorations
methanations	17	4	397	4	methanations
migrations	13	16	868	4	__migrations
mitigations	14	4	762	4	mitig_ations
navigations	15	4	520	4	navig_ations
negations	10	28	1196	4	ne__g_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
paginations	14	4	775	4	pagi_nations
patinations	13	4	1100	4	pati_nations
pectinations	16	4	925	4	pectinations
perennations	14	4	725	4	perennations
personations	14	4	839	4	personations
pinnations	12	3	688	4	__pinnations
preignitions	15	5	400	4	preignitions
recitations	13	3	1420	4	reci_tations
recognitions	15	4	485	4	recognitions
redigestions	14	8	386	4	redigestions
reignition	11	4	489	4	re_ignition_
relegations	12	4	897	4	releg_ations
remigration	14	22	891	4	remigration_
reservations	15	8	858	4	reservations
resinating	11	3	1373	4	resi_nati_ng
respirations	14	4	1030	4	respirations
restations	10	3	1584	4	res__tations
restorations	12	4	1095	4	restorations
ruinations	10	3	960	4	_rui_nations
ruminations	13	4	939	4	rumi_nations
seriations	10	3	1668	4	seri__ations
siltations	10	3	855	4	__siltations
sinuations	10	3	941	4	__sinuations
situations	10	3	843	4	__situations
stagnations	12	4	490	4	_stagnations
supinations	13	4	883	4	supi_nations
terminations	14	14	975	4	terminations
urinations	10	3	1069	4	_uri_nations
venations	12	3	1172	4	ve___nations
vernations	13	3	1033	4	ve__rnations
vesiculations	18	4	532	4	vesiculations
visitations	14	4	767	4	visi_tations

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.156	1145455.1
2	DLD Change Limit	124790	246	6.923	18025.4
3	Display Results	246	246	0.140	1757.1
	(SQL Overall)	178691	246	7.219	24752.9