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

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

61 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
expatriating	22	5	306	(None)
expatiating	21	4	436	1	expat_iating
expatriation	21	5	433	2	expatriation
expatriations	22	5	376	2	expatriations
expatriatism	23	6	282	2	expatriatism
patriating	13	5	1020	2	__patriating
repatriating	15	4	545	2	repatriating
elutriating	12	4	507	3	e_lutriating
excoriating	21	4	548	3	ex_coriating
expatiation	20	4	683	3	expat_iation
expatiations	21	4	613	3	expat_iations
expatriate	19	5	404	3	expatriat__e
expatriated	21	5	308	3	expatriat_ed
expatriates	20	5	354	3	expatriat_es
expatriatisms	24	6	228	3	expatriatisms
expiating	19	3	854	3	exp___iating
expropriating	25	5	324	3	expropriating
expurgating	22	4	328	3	exp_urgating
extricating	21	4	669	3	ex__tricating
emaciating	15	4	681	4	e_ma_ciating
empathising	19	5	207	4	empathi_sing
empathizing	28	5	280	4	empathi_zing
entreating	11	8	1155	4	e__ntreating
eradiating	12	4	873	4	e_ra_diating
estreating	11	7	1036	4	e__streating
evaporating	17	4	419	4	evapor_ating
exacerbating	24	5	235	4	exacerbating
excavating	23	4	411	4	exca__vating
excruciating	24	5	237	4	excruciating
execrating	20	4	788	4	ex_ecr_ating
exenterating	20	5	421	4	exenterating
exfoliating	22	4	339	4	ex_foliating
exonerating	19	4	555	4	exoner_ating
expatiate	18	4	542	4	expat_iat__e
expatiated	20	4	420	4	expat_iat_ed
expatiates	19	4	489	4	expat_iat_es
expectorating	25	5	206	4	expectorating
expediting	21	4	464	4	exp_edi_ting
experting	19	3	805	4	exp_er__ting
expertizing	30	4	462	4	experti_zing
explicating	23	5	612	4	exp_licating
exploiting	20	4	489	4	exp_loi_ting
exporting	19	3	732	4	exp_or__ting
expositing	20	4	535	4	exp_osi_ting
expostulating	23	6	172	4	expostulating
extirpating	21	4	374	4	ex_tirpating
extracting	20	4	722	4	ex__tracting
extubating	20	4	442	4	ex__tubating
exuberating	21	4	417	4	exuber_ating
exuviating	21	4	452	4	ex__uviating
impetrating	16	4	464	4	impetr_ating
lariating	10	3	1178	4	__la_riating
palliating	13	4	788	4	__palliating
patinating	13	3	987	4	__patinating
perpetrating	17	4	520	4	perpetr_ating
repatriation	14	12	697	4	repatriation
repatriations	15	13	651	4	repatriations
satiating	10	3	1180	4	__sat_iating
separating	13	4	864	4	sepa_r_ating
striating	10	9	1419	4	___striating
variating	13	3	1094	4	__va_riating

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.403	443402.0
2	DLD Change Limit	124790	61	7.110	17551.3
3	Display Results	61	61	0.050	1220.0
	(SQL Overall)	178691	61	7.563	23627.0