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

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

184 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
altercation	13	4	701	(None)
alteration	10	6	1290	1	alter_ation
altercations	14	4	637	1	altercations
alternation	11	4	762	1	alternation
alterations	11	5	1166	2	alter_ations
altercating	14	5	560	2	altercating
alternations	12	4	677	2	alternations
aberration	12	6	720	3	a_berration
adulteration	13	5	366	3	adulter_ation
aeration	8	3	1993	3	a__er_ation
alienation	10	4	879	3	alie_nation
allegation	11	4	681	3	alle_gation
alleviation	14	5	465	3	alleviation
alliteration	12	8	516	3	alliter_ation
allocation	12	4	857	3	al_location
altercate	11	4	785	3	altercat__e
altercated	13	4	545	3	altercat_ed
altercates	12	4	755	3	altercat_es
alternating	12	4	571	3	alternating
alternative	14	5	468	3	alternative
alternator	10	4	455	3	alternat_or
attenuation	11	4	418	3	attenuation
attestation	11	4	518	3	attestation
attraction	12	7	695	3	a_ttraction
interaction	13	4	1181	3	interaction
iteration	9	5	1503	3	_iter_ation
laceration	12	4	957	3	lacer_ation
laterization	21	4	1068	3	laterization
literation	10	5	1141	3	liter_ation
malversation	17	5	272	3	malversation
ulceration	12	4	726	3	ulcer_ation
abdication	15	4	822	4	a_bdication
aberrations	13	4	669	4	a_berrations
abjection	20	4	532	4	abje_c_tion
abjuration	19	4	588	4	abjur_ation
abnegation	13	4	541	4	abne_gation
abreaction	14	4	465	4	abreac_tion
abstraction	15	4	588	4	abstraction
acceptation	17	6	532	4	acceptation
acetylation	16	4	378	4	acetylation
activation	15	6	1013	4	act_ivation
actuation	11	3	1033	4	act__uation
adjuration	18	4	552	4	adjur_ation
admiration	13	4	773	4	admir_ation
adoration	10	3	1131	4	a_dor_ation
adulterations	14	5	317	4	adulter_ations
advection	15	4	555	4	adve_c_tion
advocation	16	4	574	4	a_dvocation
aerations	9	3	1790	4	a__er_ations
affectation	19	4	384	4	affectation
affection	17	4	589	4	affe_c_tion
affirmation	19	5	368	4	affirmation
afterpain	14	4	339	4	afterpa_i_n
aggregation	14	5	425	4	aggregation
alation	7	29	2055	4	al____ation
alienations	11	4	788	4	alie_nations
alimentation	14	10	533	4	alimentation
alkylation	17	4	382	4	al_kylation
allegations	12	4	604	4	alle_gations
alleviations	15	5	449	4	alleviations
alliterations	13	8	455	4	alliter_ations
allocations	13	4	777	4	al_locations
allocution	12	4	408	4	al_locution
alterities	10	4	1104	4	alter_ities
alternate	9	4	811	4	alternat__e
alternated	11	4	572	4	alternat_ed
alternately	14	5	277	4	alternately
alternates	10	4	787	4	alternat_es
alternatives	15	5	325	4	alternatives
alternators	11	5	410	4	alternators
annexation	17	4	495	4	anne_xation
antiquation	20	4	742	4	antiquation
appellation	15	6	412	4	appellation
apperception	17	9	346	4	apperception
application	17	4	747	4	application
appreciation	18	5	528	4	appreciation
arcuation	11	4	1058	4	a___rcuation
aspiration	12	4	999	4	aspir_ation
assentation	11	4	618	4	assentation
assertion	9	4	672	4	asser__tion
attention	9	4	610	4	atte__ntion
attenuations	12	4	380	4	attenuations
attestations	12	4	446	4	attestations
attractions	13	7	640	4	a_ttractions
attrition	9	6	696	4	a_ttr_ition
automation	12	4	914	4	aut_omation
autorotation	12	5	501	4	autorotation
avocation	14	16	899	4	a__vocation
bacterization	26	10	721	4	bacterization
bifurcation	18	6	337	4	bifurcation
botheration	16	5	465	4	bother_ation
calibration	15	4	599	4	calibr_ation
castration	12	4	1080	4	cast_r_ation
catenation	12	4	952	4	cate_nation
cauterization	24	18	775	4	cauterization
cybernation	18	4	391	4	cybernation
deaeration	11	3	1301	4	deaer_ation
defecation	16	7	980	4	defe_cation
demarcation	16	4	702	4	demarcation
denervation	15	6	794	4	denervation
deprecation	16	4	896	4	deprecation
desecration	14	4	1007	4	desecration
detection	12	13	1041	4	dete_c_tion
detestation	12	4	836	4	detestation
detraction	13	13	858	4	det_raction
deuteration	12	4	910	4	deuter_ation
election	10	20	1535	4	el_e_c_tion
elevation	12	3	923	4	el_e_vation
elutriation	11	4	671	4	elutriation
enervation	13	6	947	4	_enervation
execration	19	4	983	4	_execration
extenuation	18	4	518	4	extenuation
extirpation	20	8	492	4	extirpation
extraction	19	6	798	4	ext_raction
extrication	20	4	979	4	extrication
federation	14	4	957	4	feder_ation
filtration	13	4	643	4	filt_r_ation
flection	13	23	956	4	fl_e_c_tion
flirtation	13	5	482	4	fl_irtation
floriation	13	6	779	4	fl_oriation
furcation	14	4	835	4	__furcation
generation	11	3	1242	4	gener_ation
gleization	20	11	578	4	gl_eization
hibernation	16	4	409	4	hibernation
imprecation	17	4	654	4	imprecation
innervation	14	4	744	4	innervation
integration	12	13	1049	4	integration
interactions	14	4	1046	4	interactions
intercalation	15	5	708	4	intercalation
interception	16	4	939	4	interception
interstation	12	4	1041	4	interstation
iterations	10	4	1382	4	_iter_ations
lacerations	13	4	833	4	lacer_ations
lamentation	13	10	657	4	lamentation
laterizations	22	4	1007	4	laterizations
laureation	10	4	615	4	_laureation
lection	9	26	1486	4	_l_e_c_tion
legation	9	24	1293	4	_l_e_gation
liberation	12	6	999	4	liber_ation
libration	11	15	1016	4	_libr_ation
literations	11	6	1058	4	liter_ations
location	10	21	1391	4	_l__ocation
lubrication	15	4	634	4	_lubrication
maceration	14	4	961	4	macer_ation
malefaction	18	5	340	4	mal_efaction
malformation	19	5	332	4	malformation
malversations	18	5	256	4	malversations
mastication	15	6	1029	4	mast_ication
masturbation	16	5	358	4	masturbation
maturation	12	4	951	4	matur_ation
metrication	15	4	1065	4	metrication
moderation	13	4	865	4	moder_ation
nervation	12	6	1024	4	__nervation
nitration	9	3	1344	4	nit_r_ation
numeration	12	13	796	4	numer_ation
obliteration	14	5	389	4	obliter_ation
observation	16	6	506	4	observation
obturation	12	9	714	4	obtur_ation
operation	11	3	1400	4	_oper_ation
ostentation	11	4	696	4	ostentation
overaction	15	4	799	4	_overaction
overcaution	16	5	515	4	_overcaution
placation	13	3	977	4	pl__acation
plication	13	3	1168	4	pl__ication
reiteration	11	4	1216	4	reiter_ation
reservation	14	8	914	4	reservation
retardation	12	10	686	4	retardation
retraction	12	13	1053	4	ret_raction
saltation	9	3	1200	4	salt___ation
saturation	10	4	980	4	satur_ation
scatteration	14	5	292	4	scatter_ation
seriation	9	3	1806	4	__seriation
serration	9	4	1407	4	__serration
starvation	13	4	549	4	_starvation
striation	9	3	1348	4	_st_riation
supernation	13	4	1166	4	supernation
tarnation	9	3	1009	4	__tarnation
titration	9	3	1054	4	tit_r_ation
toleration	10	4	896	4	toler_ation
traction	10	4	1268	4	__t_raction
ulcerations	13	4	636	4	ulcer_ations
urtication	12	4	911	4	urt_ication
veneration	13	4	1234	4	vener_ation
vernation	12	3	1108	4	__vernation

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.420	425454.8
2	DLD Change Limit	148819	184	8.783	16944.0
3	Display Results	184	184	0.110	1672.7
	(SQL Overall)	178691	184	9.313	19187.3