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

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

68 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
embarkations	20	6	225	(None)
embarkation	19	7	258	1	embarkation_
debarkations	19	4	365	2	debarkations
debarkation	18	4	424	3	debarkation_
demarcations	17	4	612	3	dem_arcations
disembarkations	24	6	150	3	~~dis~~embarkations
emaciations	15	4	816	3	em_aciations
emanations	12	8	959	3	em_a_nations
embrocations	18	4	398	3	embrocations
emigrations	14	18	715	3	emigr_ations
impartations	16	13	543	3	impartations
aberrations	13	4	669	4	_aberrations
ambulations	15	4	711	4	amb_ulations
carnations	12	3	1135	4	__carnations
covariations	17	4	598	4	covariations
cybernations	19	4	360	4	cybernations
darnations	11	3	841	4	__darnations
declarations	15	4	680	4	declar_ations
demarcation	16	4	702	4	dem_arcation_
disembarkation	23	6	157	4	~~dis~~embarkation_
elaborations	14	4	492	4	elaborations
elutriations	12	4	602	4	elutriations
emaciation	14	4	928	4	em_aciation_
emanation	11	9	1078	4	em_a_nation_
emarginations	16	7	415	4	em_arginations
embarking	18	4	419	4	embark__i_ng
embolizations	26	4	672	4	embolizations
embrocation	17	4	458	4	embrocation_
emendations	14	4	605	4	em_endations
emigration	13	22	821	4	emigr_ation_
emulations	12	3	1094	4	em__ulations
enervations	14	7	857	4	e_nervations
escalations	13	4	766	4	esca_lations
evacuations	16	4	630	4	e_vacuations
evaluations	14	5	732	4	e_valuations
exaltations	18	4	729	4	e_xaltations
excavations	23	4	508	4	exca_vations
excoriations	21	4	752	4	excoriations
execrations	20	4	892	4	execr_ations
exhalations	21	4	602	4	exha_lations
exhortations	22	4	445	4	exhortations
expatiations	21	4	613	4	expatiations
expatriations	22	5	376	4	expatriations
expirations	20	6	958	4	expir_ations
exportations	21	4	665	4	exportations
expurgations	22	7	412	4	expurgations
extirpations	21	7	428	4	extirpations
fimbriations	19	4	334	4	fimb_riations
hibernations	17	4	405	4	hibernations
imbrications	18	4	568	4	imbrications
impartation	15	15	610	4	impartation_
importations	16	15	614	4	importations
incarnations	14	4	666	4	incarnations
liberations	13	5	894	4	liber_ations
librations	12	14	906	4	lib_r_ations
marathons	14	4	642	4	_m_ar_athons
marinations	13	4	1127	4	_m_arinations
migrations	13	16	868	4	_migr_ations
narrations	10	3	894	4	__narrations
remigrations	15	22	779	4	remigr_ations
reparations	13	6	1166	4	repar_ations
retardations	13	9	651	4	retardations
separations	13	6	927	4	separ_ations
starvations	14	4	505	4	_starvations
subornations	14	4	614	4	subornations
tarnations	10	3	890	4	__tarnations
variations	13	3	1077	4	__variations
vibrations	15	15	737	4	vib_r_ations

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.390	458182.1
2	DLD Change Limit	124790	68	6.873	18156.6
3	Display Results	68	68	0.033	2060.6
	(SQL Overall)	178691	68	7.296	24491.6