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

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

147 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
constipation	16	4	856	(None)
constipations	17	4	768	1	constipations
conspiration	16	4	838	2	conspiration
constipating	17	7	539	2	constipating
constitution	14	5	526	2	constitution
castigation	14	4	797	3	c_astigation
conniption	14	4	627	3	con_nip_tion
conscription	18	5	533	3	conscrip_tion
consecration	16	4	978	3	consecration
conservation	17	4	940	3	conservation
consignation	15	13	631	3	consignation
consociation	16	4	819	3	consociation
consolation	13	4	1098	3	cons_olation
consolidation	16	5	515	3	consolidation
conspirations	17	4	772	3	conspirations
constellation	15	5	479	3	constellation
consternation	15	10	636	3	consternation
constipate	14	4	639	3	constipat__e
constipated	16	4	546	3	constipat_ed
constipates	15	4	635	3	constipat_es
constitutions	15	5	486	3	constitutions
constriction	16	4	826	3	constriction
construction	16	4	808	3	construction
consultation	14	4	747	3	consultation
consummation	18	5	529	3	consummation
consumption	17	4	542	3	consump_tion
continuation	14	4	819	3	con_tinuation
contraption	15	4	810	3	con_traption
instigation	12	4	924	3	_instigation
monetization	23	5	812	3	monetization
aestivation	14	4	792	4	_aestivation
canalization	23	4	1116	4	canalization
canonization	23	4	792	4	canonization
cantillation	14	4	669	4	can_tillation
captivation	18	4	617	4	c_aptivation
castigations	15	4	720	4	c_astigations
castration	12	4	1080	4	c_ast_ration
coaptation	14	4	834	4	coapt__ation
cocultivation	20	5	305	4	cocultivation
codification	20	10	807	4	codification
cogitation	13	4	1008	4	co__gitation
cohabitation	19	5	393	4	cohabitation
colligation	14	5	744	4	co_lligation
collimation	15	5	757	4	co_llimation
colonisation	14	17	676	4	colonisation
colonization	23	20	1023	4	colonization
colorization	23	17	1119	4	colorization
combination	17	10	880	4	co_mbination
commination	17	11	1164	4	co_mmination
compilation	17	4	931	4	co_mpilation
complication	20	4	820	4	complication
conation	10	14	2088	4	con____ation
concatenation	17	6	409	4	concatenation
conception	16	4	1045	4	con_cep_tion
conciliation	16	4	823	4	conciliation
concretization	27	5	437	4	concretization
condemnation	17	4	604	4	condemnation
condensation	15	4	678	4	condensation
condition	12	4	1116	4	con_di__tion
condonation	14	4	885	4	con_donation
confirmation	19	4	618	4	confirmation
confiscation	19	4	553	4	confiscation
conflation	15	4	1208	4	con__flation
confliction	18	4	523	4	confli_ction
conformation	19	4	732	4	conformation
confutation	16	6	872	4	con_futation
congelation	14	4	1034	4	con_gelation
conglobation	17	5	425	4	conglobation
conglutination	17	6	278	4	conglutination
congregation	16	22	676	4	congregation
conjugation	21	4	662	4	con_jugation
conjuration	20	4	951	4	con_juration
connation	11	3	1426	4	con___nation
conniptions	15	4	603	4	con_nip_tions
connotation	13	4	798	4	con_notation
conscriptions	19	5	500	4	conscrip_tions
consecrations	17	4	921	4	consecrations
consecution	15	4	731	4	cons_ecution
conservations	18	4	909	4	conservations
consideration	16	5	552	4	consideration
consignations	16	10	593	4	consignations
consociations	17	4	751	4	consociations
consolations	14	4	974	4	cons_olations
consolidations	17	5	474	4	consolidations
conspirational	18	5	396	4	conspirational
conspirator	15	5	565	4	conspirat_or
constative	15	4	1010	4	const__ative
constellations	16	5	440	4	constellations
consternations	16	11	604	4	consternations
constituting	15	5	465	4	constituting
constitutional	16	6	309	4	constitutional
constitutive	17	5	410	4	constitutive
constrain	11	4	933	4	const_ra_i_n
constrictions	17	4	778	4	constrictions
constructions	17	4	771	4	constructions
consultations	15	4	693	4	consultations
consummations	19	5	515	4	consummations
consumptions	18	4	514	4	consump_tions
contagion	12	4	699	4	con_t__agion
contamination	17	6	695	4	contamination
contemplation	19	8	526	4	contemplation
contention	12	4	1222	4	con_t_ention
contestation	14	4	866	4	contestation
continuations	15	4	714	4	con_tinuations
contortion	12	4	866	4	con_t_ortion
contraction	15	4	1124	4	con_traction
contraptions	16	4	764	4	con_traptions
contribution	16	5	509	4	contribution
contrition	12	4	1141	4	con_t_rition
conurbation	15	4	746	4	con_urbation
conversation	17	4	780	4	conversation
conviction	17	4	818	4	con_vi_ction
convocation	18	4	788	4	con_vocation
coordination	15	9	558	4	coordination
cornification	20	4	669	4	cornification
corotation	12	4	1097	4	corot__ation
covariation	16	4	677	4	covari_ation
cultivation	16	11	641	4	c_ultivation
cunctation	14	7	691	4	cunct__ation
cuspidation	16	4	349	4	c_uspidation
destination	12	4	1384	4	_destination
dissipation	14	4	721	4	_dissipation
domestication	18	11	454	4	domestication
estimation	12	4	1084	4	__estimation
estivation	13	4	981	4	__estivation
fustigation	15	4	521	4	_fustigation
initiation	10	4	1210	4	_initi_ation
inspiration	13	4	837	4	_inspiration
instigations	13	4	824	4	_instigations
instillation	12	4	584	4	_instillation
institution	11	4	529	4	_institution
intimation	12	4	1304	4	_in_timation
ionization	19	4	1127	4	ion__ization
mastication	15	6	1029	4	_mastication
menstruation	14	5	522	4	menstruation
monetizations	24	6	764	4	monetizations
motivation	15	4	808	4	mo__tivation
postulation	13	11	913	4	po_stulation
reconstitution	16	6	356	4	reconstitution
robotization	23	4	686	4	robotization
rustication	13	4	922	4	_rustication
sanitization	21	4	915	4	sanitization
sensitisation	13	15	364	4	sensitisation
sensitization	22	14	672	4	sensitization
sonication	12	4	1118	4	son__ication
unitization	20	4	813	4	_unitization
ventilation	14	4	816	4	ven_tilation

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.403	443402.0
2	DLD Change Limit	124790	147	8.190	15236.9
3	Display Results	147	147	0.093	1580.6
	(SQL Overall)	178691	147	8.686	20572.3