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

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

168 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
consecration	16	4	978	(None)
consecrations	17	4	921	1	consecrations
consecrating	17	4	794	2	consecrating
consecrative	19	5	731	2	consecrative
consecrator	15	4	638	2	consecrat_or
consecution	15	4	731	2	consec_ution
conservation	17	4	940	2	conservation
consociation	16	4	819	2	consociation
conspiration	16	4	838	2	conspiration
deconsecration	19	5	478	2	deconsecration
reconsecration	18	8	556	2	reconsecration
concentration	17	5	801	3	concentration
concretion	14	4	929	3	con__cretion
condemnation	17	4	604	3	condemnation
condensation	15	4	678	3	condensation
confection	17	4	1118	3	confec__tion
confederation	19	9	525	3	confederation
congelation	14	4	1034	3	conge_lation
conjuration	20	4	951	3	con_juration
connection	14	4	1053	3	connec__tion
conscription	18	5	533	3	cons_cription
consecrate	14	4	843	3	consecrat__e
consecrated	16	4	691	3	consecrat_ed
consecrates	15	4	839	3	consecrat_es
consecrators	16	5	605	3	consecrators
consecratory	19	5	454	3	consecratory
consecutions	16	4	705	3	consec_utions
conservations	18	4	909	3	conservations
consideration	16	5	552	3	consideration
consignation	15	13	631	3	consignation
consociations	17	4	751	3	consociations
consolation	13	4	1098	3	cons_olation
conspirations	17	4	772	3	conspirations
constellation	15	5	480	3	constellation
consternation	15	10	636	3	consternation
constipation	16	4	856	3	constipation
consultation	14	4	747	3	consultation
consummation	18	5	529	3	consummation
contestation	14	4	866	3	contestation
convection	17	4	1112	3	convec__tion
conversation	17	4	780	3	conversation
convocation	18	4	788	3	convoc_ation
cooperation	15	4	1002	3	coope_ration
deconsecrations	20	6	451	3	deconsecrations
desecration	14	4	1007	3	_desecration
reconsecrations	19	9	510	3	reconsecrations
botheration	16	5	465	4	bothe_ration
cancelation	15	4	777	4	cance_lation
cancellation	16	5	501	4	cancellation
caseation	11	9	951	4	c_ase__ation
castration	12	4	1080	4	c_as_tration
celebration	15	4	646	4	c_elebration
cerebration	15	4	792	4	c_erebration
coacervation	19	6	427	4	coacervation
coarctation	15	9	507	4	co_arctation
coeducation	16	4	623	4	coeduc_ation
cogeneration	15	4	644	4	cogeneration
collection	14	4	820	4	collec__tion
collocation	15	4	717	4	colloc_ation
coloration	12	9	1318	4	co__loration
commemoration	18	5	388	4	commemoration
commendation	19	4	651	4	commendation
commiseration	19	6	404	4	commise_ration
compellation	18	5	510	4	compellation
compensation	18	12	650	4	compensation
conation	10	14	2088	4	con____ation
concelebration	20	13	356	4	concelebration
concentrations	18	7	707	4	concentrations
conception	16	4	1045	4	con__ception
concertino	14	9	1084	4	conce_r_tino
conciliation	16	4	823	4	conciliation
concoction	13	4	823	4	con__coction
concretions	15	4	929	4	con__cretions
condemnations	18	4	540	4	condemnations
condensations	16	4	627	4	condensations
condonation	14	4	885	4	con_donation
conduction	15	4	996	4	conduc__tion
confections	18	4	1139	4	confec__tions
confederations	20	10	460	4	confederations
configuration	19	5	413	4	configuration
confirmation	19	4	618	4	confirmation
confiscation	19	4	553	4	confiscation
conflagration	19	5	301	4	conflagration
conflation	15	4	1208	4	con__flation
conformation	19	4	732	4	conformation
confutation	16	6	872	4	con_futation
congelations	15	4	973	4	conge_lations
congestion	13	4	904	4	conge__stion
conglobation	17	5	425	4	conglobation
congregation	16	22	676	4	congregation
conjugation	21	4	662	4	con_jugation
conjurations	21	4	849	4	con_jurations
connation	11	3	1426	4	con___nation
connections	15	4	1070	4	connec__tions
connotation	13	4	798	4	con_notation
conscriptions	19	5	500	4	cons_criptions
consecutive	18	5	595	4	consec_utive
conservational	19	5	534	4	conservational
conservatism	19	10	495	4	conservatism
conservative	20	10	699	4	conservative
conservatize	26	12	550	4	conservatize
conservator	16	5	637	4	conservat_or
considerations	17	6	484	4	considerations
consignations	16	10	593	4	consignations
consociating	17	5	557	4	consociating
consociational	18	5	355	4	consociational
consolations	14	4	974	4	cons_olations
consolidation	16	5	515	4	consolidation
conspirational	18	5	396	4	conspirational
conspirator	15	5	565	4	conspirat_or
constellations	16	5	440	4	constellations
consternations	16	11	604	4	consternations
constipations	17	4	768	4	constipations
constitution	14	5	526	4	constitution
constrain	11	4	933	4	cons_tra_i_n
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
contemplation	19	8	526	4	contemplation
contention	12	4	1222	4	conte__ntion
contestations	15	4	773	4	contestations
continuation	14	4	819	4	continuation
contortion	12	4	866	4	con_tor_tion
contraction	15	4	1124	4	con__traction
contraption	15	4	810	4	con__traption
contrition	12	4	1141	4	con__trition
conurbation	15	4	746	4	con_urbation
convections	18	4	1149	4	convec__tions
convention	15	4	1056	4	conve__ntion
conversations	18	4	745	4	conversations
conversion	15	4	842	4	conve_r_sion
conviction	17	4	818	4	convic__tion
convocations	19	4	736	4	convoc_ations
cooperations	16	5	919	4	coope_rations
corporation	15	12	1065	4	co_rporation
correction	14	4	881	4	correc__tion
correlation	13	5	855	4	corre_lation
coruscation	15	4	569	4	corusc_ation
counteraction	17	5	538	4	counte_raction
cunctation	14	7	691	4	cun__ctation
deconsecrating	20	5	363	4	deconsecrating
desecrations	15	5	921	4	_desecrations
evisceration	17	7	300	4	evisceration
execration	19	4	983	4	__execration
exoneration	18	4	765	4	exon_e_ration
fenestration	15	9	607	4	fenestration
generation	11	3	1242	4	gen_e_ration
insertion	9	4	1059	4	_inse_r_tion
inspiration	13	4	837	4	_inspiration
integration	12	13	1049	4	_integration
mensuration	13	4	649	4	mens_uration
moderation	13	4	865	4	mo_de_ration
nonsecretor	13	5	290	4	nonsecret_or
nonsectarian	14	6	402	4	nonsectarian
nonsegregation	16	13	280	4	nonsegregation
obscuration	15	4	440	4	_obscuration
obsecrating	16	4	413	4	_obsecrating
observation	16	6	506	4	_observation
operation	11	3	1400	4	_o_pe_ration
penetration	13	4	989	4	pen_etration
reconsecrating	19	5	419	4	reconsecrating
secretion	11	11	830	4	___secretion
serration	9	4	1406	4	___serration
sonication	12	4	1118	4	son_ic_ation
toleration	10	4	896	4	to_le_ration
veneration	13	4	1234	4	ven_e_ration

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.393	454684.5
2	DLD Change Limit	124790	168	7.826	15945.6
3	Display Results	168	168	0.093	1806.5
	(SQL Overall)	178691	168	8.312	21498.0