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

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

249 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
consolation	13	4	1098	(None)
consolations	14	4	973	1	consolations
condonation	14	4	885	2	condonation
conflation	15	4	1208	2	con_flation
congelation	14	4	1034	2	congelation
connotation	13	4	798	2	connotation
consociation	16	4	819	2	consociation
consolidation	16	5	515	2	consolidation
consultation	14	4	747	2	consultation
convocation	18	4	788	2	convocation
convolution	16	4	512	2	convolution
insolation	10	4	1021	2	_insolation
nonsolution	11	5	474	2	nonsolution
cancelation	15	4	777	3	cancelation
coagulation	14	4	727	3	coagulation
coevolution	16	5	422	3	coevolution
collation	11	3	1399	3	co__llation
collocation	15	4	717	3	collocation
coloration	12	9	1318	3	co_loration
compilation	17	4	931	3	compilation
conation	10	14	2088	3	con___ation
conciliation	16	4	823	3	conciliation
concoction	13	4	823	3	conco_ction
condonations	15	4	800	3	condonations
conflations	16	4	1114	3	con_flations
conformation	19	4	732	3	conformation
confutation	16	6	872	3	confutation
congelations	15	4	973	3	congelations
conglobation	17	5	425	3	conglobation
conjugation	21	4	662	3	conjugation
conjuration	20	4	951	3	conjuration
connation	11	3	1426	3	con__nation
connotations	14	4	728	3	connotations
consecration	16	4	978	3	consecration
consecution	15	4	730	3	consecution
conservation	17	4	940	3	conservation
consignation	15	13	631	3	consignation
consociations	17	4	751	3	consociations
consolatory	16	8	496	3	consolatory
consolidations	17	5	474	3	consolidations
conspiration	16	4	838	3	conspiration
constellation	15	5	479	3	constellation
constipation	16	4	856	3	constipation
consultations	15	4	693	3	consultations
consummation	18	5	529	3	consummation
consumption	17	4	542	3	consumption
contortion	12	4	866	3	conto_rtion
conurbation	15	4	746	3	conurbation
convocations	19	4	736	3	convocations
convolutions	17	4	519	3	convolutions
copulation	14	11	1195	3	co_pulation
coronation	12	4	1207	3	co_ronation
corotation	12	4	1097	3	co_rotation
corporation	15	12	1065	3	corporation
correlation	13	5	855	3	correlation
desolation	11	3	1140	3	_desolation
disconsolation	17	6	341	3	~~dis~~consolation
insolations	11	4	918	3	_insolations
insulation	10	3	1166	3	_insulation
isolation	9	3	1164	3	__isolation
nonsolutions	12	5	417	3	nonsolutions
solation	8	9	1615	3	___solation
absolution	12	4	440	4	_absolution
angulation	11	4	955	4	_angulation
annotation	10	4	775	4	_annotation
annulation	10	6	895	4	_annulation
calculation	15	4	829	4	calculation
cancelations	16	5	709	4	cancelations
cancellation	16	5	501	4	cancellation
cantillation	14	4	669	4	cantillation
carbonation	15	4	585	4	carbonation
caseation	11	9	951	4	c_as_eation
cassation	11	9	791	4	c_as_sation
castration	12	4	1080	4	c_astration
causation	11	9	952	4	caus__ation
cessation	11	7	685	4	c_es_sation
chelation	14	3	996	4	c__helation
circulation	15	4	939	4	circulation
cisplatin	13	4	471	4	c_isplati_n
coagulations	15	4	651	4	coagulations
coalition	11	4	870	4	co__alition
coaptation	14	4	834	4	co_aptation
coarctation	15	9	507	4	coarctation
coeducation	16	4	623	4	coeducation
coevolutions	17	5	408	4	coevolutions
cogitation	13	4	1008	4	co_gitation
cognation	12	3	1075	4	co__gnation
collations	12	3	1285	4	co__llations
colligation	14	5	744	4	colligation
collimation	15	5	757	4	collimation
collocations	16	4	640	4	collocations
colorations	13	9	1189	4	co_lorations
combination	17	10	880	4	combination
commination	17	11	1164	4	commination
commotion	15	7	698	4	commo__tion
commutation	17	4	800	4	commutation
compellation	18	5	510	4	compellation
compilations	18	4	867	4	compilations
completion	16	4	730	4	co_mpletion
composition	17	4	679	4	composition
computation	17	4	871	4	computation
conations	11	13	1890	4	con___ations
conception	16	4	1045	4	con_ception
conciliations	17	4	720	4	conciliations
conclusion	14	4	522	4	con_clusion
concoctions	14	4	825	4	conco_ctions
concretion	14	4	929	4	con_cretion
condemnation	17	4	604	4	condemnation
condensation	15	4	678	4	condensation
condition	12	4	1116	4	con__dition
condolatory	17	5	423	4	condolatory
conduction	15	4	996	4	con_duction
confabulation	20	6	330	4	confabulation
confection	17	4	1118	4	con_fection
confirmation	19	4	618	4	confirmation
confiscation	19	4	553	4	confiscation
conflating	16	4	1000	4	con_flating
confliction	18	4	523	4	confliction
conformations	20	4	672	4	conformations
confrontation	18	5	322	4	confrontation
confutations	17	6	779	4	confutations
congestion	13	4	904	4	con_gestion
conglobations	18	5	394	4	conglobations
congregation	16	22	676	4	congregation
conjugations	22	4	586	4	conjugations
conjunction	22	4	562	4	conjunction
conjurations	21	4	849	4	conjurations
connations	12	3	1294	4	con__nations
connection	14	4	1053	4	con_nection
conniption	14	4	627	4	con_niption
connotational	15	5	415	4	connotational
connotative	16	6	538	4	connotative
conscription	18	5	533	4	conscription
consecrations	17	4	921	4	consecrations
consecutions	16	4	704	4	consecutions
conservations	18	4	909	4	conservations
consideration	16	5	552	4	consideration
consignations	16	10	593	4	consignations
consociating	17	5	557	4	consociating
consociational	18	5	354	4	consociational
consolidating	17	5	328	4	consolidating
consolidator	15	5	328	4	consolidat_or
consoling	12	3	1087	4	consol__ing
consortia	11	4	625	4	conso_rti_a
consorting	13	4	1074	4	conso_rting
consortium	14	5	453	4	conso_rtium
conspirations	17	4	772	4	conspirations
constative	15	4	1010	4	cons_tative
constellations	16	5	440	4	constellations
consternation	15	10	636	4	consternation
constipations	17	4	768	4	constipations
constitution	14	5	526	4	constitution
constrain	11	4	933	4	constra_i_n
constriction	16	4	826	4	constriction
construction	16	4	808	4	construction
consulate	11	6	1223	4	consulat__e
consulates	12	7	1110	4	consulat_es
consultative	17	5	478	4	consultative
consulting	13	4	908	4	consul_ting
consultive	15	4	667	4	consul_tive
consultor	11	7	647	4	consul_t_or
consummations	19	5	515	4	consummations
consumptions	18	4	514	4	consumptions
contagion	12	4	699	4	con__tagion
contemplation	19	8	526	4	contemplation
contention	12	4	1222	4	con_tention
contestation	14	4	866	4	contestation
continuation	14	4	819	4	continuation
contortions	13	4	868	4	conto_rtions
contraction	15	4	1124	4	contraction
contraption	15	4	810	4	contraption
contrition	12	4	1141	4	con_trition
conurbations	16	4	666	4	conurbations
convection	17	4	1112	4	con_vection
convention	15	4	1056	4	con_vention
conversation	17	4	780	4	conversation
conviction	17	4	818	4	con_viction
convocational	20	5	447	4	convocational
convoluting	17	4	420	4	convoluting
convulsion	15	4	443	4	convul_sion
cooperation	15	4	1002	4	cooperation
cooption	12	8	834	4	co__o_ption
copulations	15	11	1111	4	co_pulations
coronations	13	4	1070	4	co_ronations
corotations	13	4	976	4	co_rotations
corporations	16	12	948	4	corporations
correlations	14	4	786	4	correlations
corrugation	14	4	599	4	corrugation
coruscation	15	4	569	4	coruscation
covariation	16	4	677	4	covariation
crenelation	13	4	685	4	crenelation
crenellation	14	5	391	4	crenellation
crenulation	13	4	757	4	crenulation
cumulation	14	4	817	4	c_umulation
cunctation	14	7	691	4	cun_ctation
cupellation	15	4	414	4	cupellation
denotation	11	3	1108	4	den_otation
desolations	12	3	1059	4	_desolations
disconsolations	18	6	320	4	~~dis~~consolations
dissolution	12	14	502	4	dissolution
donation	9	15	1378	4	don___ation
etiolation	10	4	853	4	_etiolation
exsolution	17	4	376	4	_exsolution
formulation	16	4	636	4	formulation
immolation	14	4	610	4	_immolation
inflation	12	3	1109	4	_in_flation
inhalation	13	10	766	4	_inhalation
innovation	13	4	564	4	_innovation
inoculation	13	5	871	4	inoculation
inosculation	14	4	527	4	inosculation
insolating	11	4	915	4	_insolating
insulations	11	3	1023	4	_insulations
intonation	10	4	1026	4	_intonation
invocation	15	4	754	4	_invocation
involution	13	4	594	4	_involution
ionization	19	4	1127	4	ion_ization
isolations	10	3	1069	4	__isolations
lobulation	12	4	723	4	lo_bulation
mensuration	13	4	649	4	mensuration
modulation	13	14	793	4	mo_dulation
morulation	12	14	890	4	mo_rulation
nodulation	11	12	799	4	no_dulation
nonvolatile	14	5	317	4	nonvolatile
notation	8	14	1460	4	__n_otation
novation	11	17	1001	4	__n_ovation
oblation	10	3	986	4	_o__blation
osculation	12	4	967	4	_osculation
ovulation	12	3	898	4	_o_vulation
ozonation	18	4	567	4	_o_zonation
percolation	15	4	922	4	percolation
personation	13	4	948	4	personation
podsolization	25	16	500	4	podsolization
population	14	8	1002	4	po_pulation
postisolation	15	5	356	4	postisolation
postulation	13	11	913	4	postulation
renovation	13	5	878	4	ren_ovation
resolution	10	9	773	4	_resolution
sensation	9	5	1058	4	sens__ation
solations	9	8	1462	4	___solations
solution	8	8	959	4	___solution
solvation	12	3	777	4	___solvation
sonication	12	4	1118	4	son_ication
syncopation	18	5	325	4	syncopation
translation	11	4	948	4	trans_lation
undulation	11	4	710	4	_undulation
vacuolation	16	4	439	4	vacuolation
ventilation	14	4	816	4	ventilation
violation	12	3	844	4	__violation
zonation	17	14	1072	4	zon___ation

Search took 10 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	148819	0.153	1167915.0
2	DLD Change Limit	148819	249	9.283	16031.3
3	Display Results	249	249	0.140	1778.6
	(SQL Overall)	178691	249	9.576	18660.3