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

Here are the results of your fuzzy-string dictionary search for “consignation” 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
consignation	15	13	631	(None)
consignations	16	10	593	1	consignations
assignation	12	4	437	3	_assignation
cognation	12	3	1075	3	co___gnation
colligation	14	5	745	3	collig_ation
combination	17	10	880	3	combi_nation
commination	17	11	1164	3	commi_nation
conciliation	16	4	823	3	conciliation
condemnation	17	4	604	3	condemnation
condonation	14	4	885	3	con_donation
configuration	19	5	413	3	configuration
confirmation	19	4	618	3	confirmation
confiscation	19	4	553	3	confiscation
conjugation	21	4	662	3	conjug_ation
connation	11	3	1426	3	con___nation
consecration	16	4	978	3	consecration
conservation	17	4	940	3	conservation
consideration	16	5	552	3	consideration
consociation	16	4	819	3	consociation
consolation	13	4	1098	3	cons_olation
conspiration	16	4	838	3	conspiration
consternation	15	10	636	3	consternation
constipation	16	4	856	3	constipation
consultation	14	4	747	3	consultation
consummation	18	5	529	3	consummation
continuation	14	4	819	3	continuation
designation	13	4	748	3	_designation
indignation	13	4	653	3	_indignation
resignation	12	4	747	3	_resignation
assignations	13	4	416	4	_assignations
bombination	17	6	501	4	bombi_nation
cachinnation	19	7	242	4	cachinnation
calcination	15	4	890	4	calci_nation
cantillation	14	4	669	4	cantillation
castigation	14	4	797	4	castig_ation
cogitation	13	4	1008	4	co_gi_tation
cognations	13	3	959	4	co___gnations
cognition	12	4	701	4	co___gnition
colligations	15	5	684	4	collig_ations
collimation	15	5	757	4	colli_mation
combinations	18	9	792	4	combi_nations
comminations	18	8	1048	4	commi_nations
comminution	17	10	501	4	commi_nution
compilation	17	4	931	4	compi_lation
conation	10	14	2088	4	co____nation
concatenation	17	6	409	4	concatenation
conciliations	17	4	720	4	conciliations
condemnations	18	4	540	4	condemnations
condensation	15	4	678	4	condensation
condition	12	4	1116	4	condi___tion
condonations	15	4	800	4	con_donations
configurations	20	6	370	4	configurations
confirmations	20	5	567	4	confirmations
confiscations	20	4	495	4	confiscations
conflagration	19	5	301	4	conflagration
conflation	15	4	1208	4	con__flation
conformation	19	4	732	4	conformation
confrontation	18	5	322	4	confrontation
confutation	16	6	872	4	con_futation
congelation	14	4	1034	4	con_gelation
congestion	13	4	904	4	con__gestion
conglobation	17	5	425	4	conglobation
congregation	16	22	676	4	congregation
conjugations	22	4	586	4	conjug_ations
conjunction	22	4	562	4	con_junction
conjuration	20	4	951	4	con_juration
connations	12	3	1294	4	con___nations
conniption	14	4	627	4	conni__ption
connotation	13	4	798	4	con_notation
conscription	18	5	533	4	conscription
consecrations	17	4	921	4	consecrations
consecution	15	4	731	4	cons_ecution
conservations	18	4	909	4	conservations
considerations	17	6	484	4	considerations
consignable	16	5	428	4	consigna_ble
consigning	14	4	678	4	consign__ing
consignor	12	4	411	4	consign___or
consociations	17	4	751	4	consociations
consolations	14	4	974	4	cons_olations
consolidation	16	5	515	4	consolidation
conspirations	17	4	772	4	conspirations
constellation	15	5	480	4	constellation
consternations	16	11	604	4	consternations
constipations	17	4	768	4	constipations
constitution	14	5	526	4	constitution
constriction	16	4	826	4	constriction
construction	16	4	808	4	construction
consultations	15	4	693	4	consultations
consummations	19	5	515	4	consummations
consumption	17	4	542	4	cons_umption
contamination	17	6	695	4	contamination
contention	12	4	1222	4	con_ten_tion
contestation	14	4	866	4	contestation
continuations	15	4	714	4	continuations
conurbation	15	4	746	4	con_urbation
convention	15	4	1056	4	con_ven_tion
conversation	17	4	780	4	conversation
conviction	17	4	818	4	convi__ction
convocation	18	4	788	4	con_vocation
coordination	15	9	558	4	coordination
coronation	12	4	1207	4	co__ronation
corrugation	14	4	599	4	corrug_ation
cosignatory	17	5	294	4	co_signatory
crimination	15	4	941	4	crimi_nation
culmination	15	5	764	4	culmi_nation
denigration	13	4	846	4	den_igration
designations	14	5	694	4	_designations
domination	13	7	1237	4	do_mi_nation
indignations	14	4	604	4	_indignations
insinuation	11	13	726	4	_insinuation
instigation	12	4	924	4	_instig_ation
iodination	11	5	998	4	io_di_nation
ionization	19	4	1127	4	ion_i_zation
nomination	12	7	1210	4	no_mi_nation
obligation	13	4	678	4	_oblig_ation
ordination	11	4	941	4	_ordi_nation
origination	12	6	709	4	_o_rigination
pollination	13	4	801	4	polli_nation
resignations	13	4	688	4	_resignations
sonication	12	4	1118	4	son_i_cation

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.393	454684.5
2	DLD Change Limit	124790	120	7.203	17324.7
3	Display Results	120	120	0.063	1904.8
	(SQL Overall)	178691	120	7.659	23330.9