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

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

120 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
consignations	16	10	593	(None)
consignation	15	13	631	1	consignation_
assignations	13	4	416	3	_assignations
cognations	13	3	959	3	co___gnations
colligations	15	5	683	3	collig_ations
combinations	18	9	792	3	combi_nations
comminations	18	8	1048	3	commi_nations
conciliations	17	4	720	3	conciliations
condemnations	18	4	540	3	condemnations
condonations	15	4	800	3	con_donations
configurations	20	6	370	3	configurations
confirmations	20	5	567	3	confirmations
confiscations	20	4	495	3	confiscations
conjugations	22	4	586	3	conjug_ations
connations	12	3	1294	3	con___nations
consecrations	17	4	921	3	consecrations
conservations	18	4	909	3	conservations
considerations	17	6	484	3	considerations
consociations	17	4	751	3	consociations
consolations	14	4	974	3	cons_olations
conspirations	17	4	772	3	conspirations
consternations	16	11	604	3	consternations
constipations	17	4	768	3	constipations
consultations	15	4	693	3	consultations
consummations	19	5	515	3	consummations
continuations	15	4	714	3	continuations
designations	14	5	694	3	_designations
indignations	14	4	604	3	_indignations
resignations	13	4	688	3	_resignations
assignation	12	4	437	4	_assignation_
bombinations	18	8	459	4	bombi_nations
cachinnations	20	9	212	4	cachinnations
calcinations	16	4	793	4	calci_nations
cantillations	15	4	573	4	cantillations
castigations	15	4	720	4	castig_ations
cogitations	14	4	890	4	co_gi_tations
cognation	12	3	1075	4	co___gnation_
cognitions	13	4	604	4	co___gnitions
colligation	14	5	744	4	collig_ation_
collimations	16	5	687	4	colli_mations
combination	17	10	880	4	combi_nation_
commination	17	11	1164	4	commi_nation_
comminutions	18	9	431	4	commi_nutions
compilations	18	4	868	4	compi_lations
conations	11	13	1890	4	co____nations
concatenations	18	7	372	4	concatenations
conciliation	16	4	823	4	conciliation_
condemnation	17	4	604	4	condemnation_
condensations	16	4	627	4	condensations
conditions	13	4	1010	4	condi___tions
condonation	14	4	885	4	con_donation_
configuration	19	5	413	4	configuration_
confirmation	19	4	618	4	confirmation_
confiscation	19	4	553	4	confiscation_
conflagrations	20	5	272	4	conflagrations
conflations	16	4	1114	4	con__flations
conformations	20	4	672	4	conformations
confrontations	19	6	278	4	confrontations
confutations	17	6	779	4	con_futations
congelations	15	4	973	4	con_gelations
congestions	14	4	931	4	con__gestions
conglobations	18	5	394	4	conglobations
congregations	17	18	641	4	congregations
conjugation	21	4	662	4	conjug_ation_
conjunctions	23	4	538	4	con_junctions
conjurations	21	4	849	4	con_jurations
connation	11	3	1426	4	con___nation_
conniptions	15	4	603	4	conni__ptions
connotations	14	4	728	4	con_notations
conscientious	17	10	225	4	conscien_tious
conscriptions	19	5	500	4	conscriptions
consecration	16	4	978	4	consecration_
consecutions	16	4	704	4	cons_ecutions
conservation	17	4	940	4	conservation_
consideration	16	5	552	4	consideration_
consigning	14	4	678	4	consign__i_ng
consignors	13	4	430	4	consign___ors
consociation	16	4	819	4	consociation_
consolation	13	4	1098	4	cons_olation_
consolidations	17	5	474	4	consolidations
conspiration	16	4	838	4	conspiration_
constellations	16	5	440	4	constellations
consternation	15	10	636	4	consternation_
constipation	16	4	856	4	constipation_
constitutions	15	5	486	4	constitutions
constrictions	17	4	778	4	constrictions
constructions	17	4	771	4	constructions
consultation	14	4	747	4	consultation_
consummation	18	5	529	4	consummation_
consumptions	18	4	514	4	cons_umptions
contaminations	18	8	610	4	contaminations
contentions	13	4	1209	4	con_ten_tions
contestations	15	4	773	4	contestations
continuation	14	4	819	4	continuation_
conurbations	16	4	666	4	con_urbations
conventions	16	4	1053	4	con_ven_tions
conversations	18	4	745	4	conversations
convictions	18	4	804	4	convi__ctions
convocations	19	4	736	4	con_vocations
coordinations	16	8	499	4	coordinations
coronations	13	4	1070	4	co__ronations
corrugations	15	6	548	4	corrug_ations
cosignatory	17	5	294	4	co_signat_ory
criminations	16	4	806	4	crimi_nations
culminations	16	4	653	4	culmi_nations
denigrations	14	4	735	4	den_igrations
designation	13	4	748	4	_designation_
dominations	14	6	1104	4	do_mi_nations
indignation	13	4	653	4	_indignation_
insinuations	12	13	642	4	_insinuations
instigations	13	4	824	4	_instig_ations
iodinations	12	6	884	4	io_di_nations
ionizations	20	4	989	4	ion_i_zations
nominations	13	4	1053	4	no_mi_nations
obligations	14	4	614	4	_oblig_ations
ordinations	12	4	799	4	_ordi_nations
originations	13	10	618	4	_o_riginations
pollinations	14	4	723	4	polli_nations
resignation	12	4	747	4	_resignation_
sonications	13	4	995	4	son_i_cations

Search took 7 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	95024	0.390	458182.1
2	DLD Change Limit	95024	120	5.796	16394.8
3	Display Results	120	120	0.063	1904.8
	(SQL Overall)	178691	120	6.249	28595.1