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

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

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.

76 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
expiration	19	6	1071	(None)
expiation	18	7	1042	1	expi_ation
expirations	20	6	958	1	expirations
aspiration	12	4	999	2	aspiration
epilation	11	3	1296	2	e_pilation
excitation	19	4	1017	2	excitation
execration	19	4	983	2	execration
expiations	19	5	966	2	expi_ations
explication	22	4	845	2	explication
exploration	20	6	671	2	exploration
exportation	20	4	744	2	exportation
expurgation	21	5	455	2	expurgation
extirpation	20	8	492	2	extirpation
respiration	13	5	1119	2	respiration
admiration	13	4	773	3	admiration
aspirations	13	4	899	3	aspirations
capitation	14	3	1136	3	capitation
depilation	13	3	1203	3	depilation
desperation	14	5	1011	3	desperation
emigration	13	22	821	3	emigration
epilations	12	3	1171	3	e_pilations
equitation	19	4	834	3	equitation
estimation	12	4	1084	3	estimation
estivation	13	4	981	3	estivation
evaporation	16	4	555	3	evaporation
exaltation	17	4	849	3	exaltation
examination	20	5	845	3	examination
exasperation	21	5	402	3	exasperation
excavation	22	4	543	3	excavation
excerption	21	4	506	3	excerption
excitations	20	4	900	3	excitations
excoriation	20	4	843	3	excoriation
excretion	18	4	671	3	ex_cretion
execrations	20	4	892	3	execrations
exertion	15	3	1008	3	ex_er_tion
exhalation	20	4	665	3	exhalation
exhibition	22	5	383	3	exhibition
exhilaration	22	5	252	3	exhilaration
exhortation	21	4	502	3	exhortation
exhumation	22	4	469	3	exhumation
exoneration	18	4	765	3	exoneration
expatiation	20	4	683	3	expatiation
expatriation	21	5	433	3	expatriation
expectation	22	6	648	3	expectation
expedition	20	4	490	3	expedition
expiating	19	3	854	3	expi_ating
expiator	17	4	704	3	expi_at_or
expiratory	22	4	473	3	expiratory
explanation	20	4	526	3	explanation
explications	23	4	753	3	explications
exploitation	21	5	470	3	exploitation
explorations	21	8	561	3	explorations
exportations	21	4	665	3	exportations
exposition	19	4	716	3	exposition
expunction	21	4	357	3	expunction
expurgations	22	7	412	3	expurgations
exsertion	16	4	685	3	exser_tion
exsiccation	22	4	362	3	exsiccation
extinction	19	4	477	3	extinction
extirpations	21	7	428	3	extirpations
extortion	16	4	672	3	extor_tion
extraction	19	6	798	3	ex_traction
extrication	20	4	979	3	extrication
exudation	17	8	769	3	ex_udation
exultation	17	4	753	3	exultation
exuviation	20	11	634	3	exuviation
inspiration	13	4	837	3	inspiration
operation	11	3	1400	3	_operation
oxidation	17	4	632	3	ox_idation
perspiration	16	5	683	3	perspiration
reoperation	13	4	1090	3	reoperation
reparation	12	6	1272	3	reparation
respirations	14	4	1030	3	respirations
separation	12	5	1043	3	separation
supination	12	4	988	3	supination
suspiration	13	4	654	3	suspiration

Search took 7 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	140603	0.406	440125.6
2	DLD Change Limit	140603	76	5.623	25005.0
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	6.062	29477.2