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

Here are the results of your fuzzy-string dictionary search for “expatriations” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

78 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
expatriations	22	5	376	(None)
expatiations	21	4	613	1	expat_iations
expatriation	21	5	433	1	expatriation_
expatiation	20	4	683	2	expat_iation_
expatriating	22	5	306	2	expatriati_ng
expatriatisms	24	6	228	2	expatriatisms
repatriations	15	13	651	2	repatriations
elutriations	12	4	602	3	e_lutriations
excoriations	21	4	752	3	ex_coriations
expatiating	21	4	436	3	expat_iati_ng
expatriates	20	5	354	3	expatriat__es
expatriatism	23	6	282	3	expatriati_sm
expiations	19	5	966	3	exp___iations
expirations	20	6	958	3	exp_ir_ations
explorations	21	8	561	3	explor_ations
exportations	21	4	665	3	exp_ortations
expropriations	25	5	332	3	expropriations
expurgations	22	7	412	3	exp_urgations
extrications	21	4	905	3	ex__trications
repatriation	14	12	697	3	repatriation_
apparitions	15	4	407	4	appa_ri_tions
bipartitions	16	15	254	4	biparti_tions
cicatrizations	27	9	491	4	cicatrizations
covariations	17	4	598	4	cova_riations
elutriation	11	4	671	4	e_lutriation_
emaciations	15	4	816	4	e_ma_ciations
embarkations	20	6	225	4	emba_rkations
evaporations	17	4	469	4	evapor_ations
exacerbations	24	5	250	4	exacerbations
exaltations	18	4	729	4	ex_a_ltations
examinations	21	6	746	4	ex_aminations
excavations	23	4	508	4	exca__vations
excitations	20	4	900	4	excit__ations
excoriation	20	4	843	4	ex_coriation_
excruciations	24	11	299	4	excruciations
execrations	20	4	892	4	ex_ecr_ations
exenterations	20	5	448	4	exenterations
exfoliations	22	4	478	4	ex_foliations
exhalations	21	4	602	4	exha__lations
exhortations	22	4	445	4	ex_hortations
exonerations	19	4	701	4	exoner_ations
expatiates	19	4	489	4	expat_iat__es
expatriate	19	5	404	4	expatriat___e
expatriated	21	5	308	4	expatriat__ed
expectations	23	6	584	4	exp_ectations
expectorations	25	5	219	4	expectorations
expeditions	21	4	463	4	exp_edi_tions
expiation	18	7	1042	4	exp___iation_
expiration	19	6	1071	4	exp_ir_ation_
explanations	21	4	462	4	exp_lanations
explantations	22	5	364	4	explantations
explications	23	4	753	4	exp_lications
exploitations	22	5	421	4	exploitations
exploration	20	6	671	4	explor_ation_
exportation	20	4	744	4	exp_ortation_
expositions	20	4	684	4	exp_osi_tions
expostulations	23	5	230	4	expostulations
expropriation	24	5	399	4	expropriation_
expurgation	21	5	455	4	exp_urgation_
extirpations	21	7	428	4	ex_tirpations
extractions	20	7	774	4	ex__tractions
extrication	20	4	979	4	ex__trication_
exultations	18	4	652	4	exult__ations
exuviations	21	9	569	4	ex__uviations
impartations	16	13	543	4	impa_rtations
impetrations	16	4	544	4	impetr_ations
palliations	13	4	772	4	__palliations
partitions	12	4	832	4	__parti_tions
patinations	13	4	1100	4	__patinations
patriating	13	5	1020	4	__patriati_ng
perpetrations	17	4	637	4	perpetr_ations
reparations	13	6	1166	4	repa_r_ations
repartitions	14	4	496	4	reparti_tions
repatriating	15	4	545	4	repatriati_ng
satiations	10	3	1211	4	__sat_iations
separations	13	6	927	4	sepa_r_ations
striations	10	3	1279	4	___striations
variations	13	3	1077	4	__va_riations

Search took 6 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	95024	0.390	458182.1
2	DLD Change Limit	95024	78	5.390	17629.7
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	5.826	30671.3