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

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

231 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
defalcations	18	4	519	(None)
defalcation	17	4	622	1	defalcation_
dealations	11	3	1137	2	de_al_ations
defalcating	18	4	434	2	defalcati_ng
defalcators	17	4	286	2	defalcat_ors
defamations	17	4	589	2	defa_mations
defecations	17	7	900	2	def_ecations
deflations	14	3	971	2	def_l_ations
defoliations	16	4	759	2	defoliations
demarcations	17	4	612	2	demarcations
devaluations	16	4	635	2	devaluations
deaerations	12	3	1167	3	de_aerations
dealation	10	3	1300	3	de_al_ation_
debarkations	19	4	365	3	debarkations
decantations	15	4	794	3	decantations
declamations	17	4	530	3	declamations
declarations	15	4	680	3	declarations
decollations	15	4	736	3	decollations
dedications	15	3	1087	3	de_dications
defalcates	16	4	454	3	defalcat__es
defalcator	16	4	317	3	defalcat_o_r
defamation	16	4	684	3	defa_mation_
defecation	16	7	980	3	def_ecation_
defections	16	15	1020	3	def_ec_tions
deflagrations	18	8	302	3	deflagrations
deflation	13	3	1065	3	def_l_ation_
deflections	17	18	732	3	def_lections
deflorations	16	4	606	3	deflorations
defoliation	15	4	831	3	defoliation_
deformations	18	4	684	3	deformations
deglaciations	17	5	391	3	deglaciations
deifications	18	4	1065	3	deifications
delations	10	26	1659	3	de__l_ations
demarcation	16	4	702	3	demarcation_
depilations	14	3	1090	3	depil_ations
deprecations	17	4	856	3	deprecations
desalinations	14	4	1018	3	desalinations
desiccations	17	5	565	3	desiccations
desolations	12	3	1059	3	desol_ations
devaluation	15	4	707	3	devaluation_
devastations	16	4	582	3	devastations
evaluations	14	5	732	3	_evaluations
exaltations	18	4	729	3	_exaltations
reflations	13	3	1123	3	ref_l_ations
retaliations	12	5	1140	3	retaliations
revaluations	15	5	763	3	revaluations
affiliations	18	4	418	4	affiliations
alations	8	25	1889	4	___al_ations
bifurcations	19	8	293	4	bifurcations
dalmatians	13	4	356	4	d__almatians
damnations	13	3	708	4	d__amnations
darnations	11	3	841	4	d__arnations
deaeration	11	3	1301	4	de_aeration_
deaminations	15	10	1013	4	deaminations
debarkation	18	4	424	4	debarkation_
debilitations	16	4	713	4	debilitations
decantation	14	4	894	4	decantation_
decapitations	18	4	766	4	decapitations
decelerations	16	4	642	4	decelerations
decimations	16	4	1016	4	de_cimations
declamation	16	4	610	4	declamation_
declaration	14	4	783	4	declaration_
declinations	15	4	1022	4	declinations
decoctions	15	4	714	4	de_coc_tions
decollation	14	4	819	4	decollation_
decorations	14	3	1288	4	de_corations
decussations	15	4	367	4	decussations
dedication	14	3	1196	4	de_dication_
deductions	14	6	713	4	de_duc_tions
defalcate	15	4	492	4	defalcat___e
defalcated	17	4	418	4	defalcat__ed
defecating	17	23	778	4	def_ecati_ng
defecators	16	5	625	4	def_ecat_ors
defection	15	16	1064	4	def_ec_tion_
definitions	15	4	560	4	def_initions
deflagration	17	7	347	4	deflagration_
deflating	14	26	1071	4	def_l_ati_ng
deflators	13	34	815	4	def_l_at_ors
deflection	16	14	773	4	def_lection_
deflexions	21	4	256	4	def_l_exions
defloration	15	4	726	4	defloration_
defoliating	16	4	582	4	defoliati_ng
defoliators	15	4	372	4	defoliat_ors
deformation	17	4	766	4	deformation_
deglaciation	16	5	430	4	deglaciation_
degradations	15	4	455	4	degradations
degustations	14	4	483	4	degustations
dehydrations	20	4	340	4	dehydrations
deification	17	4	1166	4	deification_
dejections	20	16	835	4	de_jec_tions
delaminations	16	4	794	4	delaminations
delation	9	23	1808	4	de__l_ation_
delectations	15	4	745	4	delectations
delegations	13	4	803	4	de_legations
deletions	10	26	1093	4	de__l_etions
delineations	13	4	676	4	delineations
demarcating	17	4	520	4	demarcati_ng
demolitions	14	4	652	4	demol_itions
denaturations	14	4	495	4	denaturations
denegations	13	4	854	4	de_negations
denervations	16	5	709	4	denervations
denigrations	14	4	735	4	denigrations
denotations	12	3	985	4	de_notations
dentations	11	4	1363	4	de__ntations
denudations	13	4	634	4	de_nudations
denunciations	16	5	388	4	denunciations
deoxidations	21	4	524	4	deoxidations
depictions	15	4	689	4	de_pic_tions
depilation	13	3	1203	4	depil_ation_
depletions	13	5	574	4	de_pl_etions
deportations	15	4	846	4	deportations
depravations	18	8	537	4	depravations
deprecation	16	4	896	4	deprecation_
depreciations	18	4	658	4	depreciations
depredations	16	4	673	4	depredations
deprivations	18	9	792	4	deprivations
deputations	14	4	834	4	de_putations
deracinations	16	4	783	4	deracinations
derealizations	24	9	1081	4	derealizations
derelictions	15	4	433	4	derelictions
derivations	15	6	1149	4	de_rivations
derogations	13	4	939	4	de_rogations
desalination	13	4	1113	4	desalination_
desecrations	15	5	921	4	desecrations
desiccation	16	4	638	4	desiccation_
designations	14	5	694	4	designations
desolation	11	3	1140	4	desol_ation_
desperations	15	5	952	4	desperations
despoliations	16	4	639	4	despoliations
destinations	13	4	1266	4	destinations
detections	13	14	1004	4	de_tec_tions
detestations	13	4	758	4	detestations
detonations	12	3	937	4	de_tonations
detoxications	23	5	565	4	detoxications
detractions	14	11	827	4	detrac_tions
deuterations	13	4	808	4	deuterations
devaluating	16	4	505	4	devaluati_ng
devastation	15	4	673	4	devastation_
deviations	14	3	1117	4	de__viations
devolutions	15	10	626	4	devol_utions
diffractions	21	5	327	4	diffractions
dilatations	12	4	641	4	dila_tations
dilations	10	26	1445	4	d__il_ations
dislocations	15	13	698	4	dislocations
divagations	16	10	383	4	diva_gations
divarications	19	5	550	4	divarications
duplications	17	4	628	4	duplications
edifications	18	4	869	4	edifications
educations	13	3	923	4	_e_ducations
elations	8	37	1912	4	_e__l_ations
emaciations	15	4	816	4	_emaciations
emanations	12	8	959	4	_ema_nations
emulations	12	3	1094	4	_emul_ations
epilations	12	3	1171	4	_epil_ations
eradications	15	4	931	4	_eradications
escalations	13	4	766	4	escal_ations
evacuations	16	4	630	4	_evacuations
evaluation	13	5	818	4	_evaluation_
evocations	15	25	987	4	_e_vocations
exactions	18	3	892	4	_exa_c_tions
exaltation	17	4	849	4	_exaltation_
exfoliations	22	4	478	4	exfoliations
exhalations	21	4	602	4	exhal_ations
explications	23	4	753	4	_explications
exultations	18	4	652	4	_exultations
factions	13	30	1306	4	__fa_c_tions
falchions	17	4	391	4	__falc_hions
fasciations	16	4	626	4	__fasciations
fellations	13	3	806	4	__fellations
filiations	13	11	909	4	__filiations
foliations	13	9	994	4	__foliations
furcations	15	4	753	4	__furcations
gelations	10	25	1309	4	ge__l_ations
halations	12	3	1239	4	__hal_ations
idealizations	23	7	945	4	ide_alizations
inculcations	16	6	631	4	inculcations
infarctions	16	4	502	4	infarc_tions
infatuations	15	4	443	4	infatuations
inflations	13	3	1032	4	inf_l_ations
inhalations	14	12	674	4	inhal_ations
lallations	10	3	874	4	__lallations
legalizations	23	4	1067	4	legalizations
medications	16	4	993	4	me_dications
metrications	16	4	983	4	metrications
obfuscations	19	5	189	4	obfuscations
olfactions	15	6	387	4	olfa_c_tions
palmations	14	3	873	4	__palmations
palpations	14	3	765	4	__palpations
peculations	15	3	1028	4	pecul_ations
peltations	12	3	1155	4	pe__ltations
penalizations	24	5	1163	4	penalizations
placations	14	3	858	4	_pla_cations
reactions	11	7	1171	4	re_a_c_tions
realizations	21	4	1553	4	re_alizations
reallocations	15	5	380	4	reallocations
recalculations	18	10	403	4	recalculations
recantations	14	4	887	4	recantations
reclamations	16	4	571	4	reclamations
redactions	13	5	913	4	reda_c_tions
reeducations	15	4	547	4	reeducations
reevaluations	16	5	427	4	reevaluations
refections	15	18	1164	4	ref_ec_tions
reflation	12	4	1233	4	ref_l_ation_
reflections	16	17	855	4	ref_lections
reformations	17	4	760	4	reformations
refractions	16	12	772	4	refrac_tions
refutations	14	4	867	4	ref_utations
regulations	12	3	1071	4	regul_ations
reifications	17	4	1182	4	reifications
relations	9	24	1833	4	re__l_ations
relaxations	18	4	564	4	rela_xations
relocations	13	3	1114	4	re_locations
reparations	13	6	1166	4	repa_rations
replications	16	8	1105	4	replications
reradiations	13	4	949	4	reradiations
retaliation	11	6	1232	4	retaliation_
retardations	13	9	651	4	retardations
revalidations	17	4	711	4	revalidations
revaluation	14	5	814	4	revaluation_
revelations	14	4	1030	4	revel_ations
revocations	16	4	1031	4	re_vocations
saltations	10	3	1062	4	__saltations
salvations	13	3	813	4	__salvations
scalations	12	3	978	4	_scal_ations
separations	13	6	927	4	sepa_rations
spallations	13	5	610	4	_spallations
suffocations	20	5	309	4	suffocations
sulcations	12	8	958	4	__sulcations
vacations	14	19	1055	4	__va_cations
vallations	13	3	909	4	__vallations
valuations	13	4	878	4	__valuations

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.406	440125.6
2	DLD Change Limit	124790	231	6.860	18191.0
3	Display Results	231	231	0.123	1878.0
	(SQL Overall)	178691	231	7.389	24183.4