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

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

79 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
aspirating	13	4	836	(None)
asperating	13	4	956	1	asperating
aspiration	12	4	999	2	aspiration
aspirations	13	4	899	2	aspirations
aspiring	11	3	887	2	aspir__ing
auspicating	16	4	460	2	auspicating
pirating	11	3	1451	2	__pirating
spiraling	12	3	795	2	_spiraling
spiriting	12	3	841	2	_spiriting
spirting	11	29	1363	2	_spir_ting
abdicating	16	8	615	3	abdicating
acierating	13	4	832	3	acierating
activating	16	4	786	3	activating
aerating	9	28	2100	3	a__erating
aestivating	15	4	580	3	aestivating
agitating	11	3	886	3	a_gitating
airting	8	36	1630	3	a__ir_ting
amputating	15	4	510	3	amputating
animating	12	3	1251	3	a_nimating
arbitrating	14	4	479	3	arbitrating
asparagine	13	5	334	3	asparagine
aspersing	12	3	760	3	asper_sing
asphalting	16	4	338	3	asphalting
aspirant	10	4	886	3	aspira__nt
aspirata	10	5	499	3	aspirat__a
aspiratae	11	4	335	3	aspirat_ae
aspirate	10	3	994	3	aspirat__e
aspirated	12	4	770	3	aspirat_ed
aspirates	11	3	961	3	aspirat_es
aspirational	14	5	500	3	aspirational
aspirator	11	4	728	3	aspirat_or
aspirators	12	4	700	3	aspirators
aspirin	9	3	782	3	aspir__in_
aspirins	10	3	773	3	aspir__ins
asserting	10	3	866	3	asser_ting
assisting	10	4	618	3	assi_sting
assorting	10	3	730	3	assor_ting
astricting	13	5	783	3	astricting
aviating	12	3	1102	3	a_vi_ating
castigating	15	4	600	3	castigating
castrating	13	4	977	3	cas_trating
depilating	14	3	919	3	depilating
depurating	14	3	864	3	depurating
dispiriting	15	4	594	3	dispiriting
epilating	12	3	1097	3	_epilating
estimating	13	4	888	3	estimating
estivating	14	4	763	3	estivating
exasperating	22	5	318	3	exasperating
expiating	19	3	854	3	expi_ating
fascinating	17	4	525	3	fascinating
inspiriting	14	4	364	3	inspiriting
lapidating	14	4	524	3	lapidating
masticating	16	4	783	3	masticating
operating	12	3	1372	3	_operating
opiating	11	4	1009	3	_opi_ating
oppilating	15	4	486	3	oppilating
palpitating	16	4	465	3	palpitating
passivating	17	4	378	3	passivating
prating	10	34	2445	3	__p_rating
salivating	14	4	744	3	salivating
sanitating	11	4	965	3	sanitating
satiating	10	3	1181	3	sati_ating
saturating	11	11	920	3	saturating
separating	13	4	864	3	separating
seriating	10	9	1640	3	_seriating
serrating	10	5	1320	3	_serrating
shirting	12	32	1361	3	_shir_ting
skirting	13	28	939	3	_skir_ting
spiralling	13	4	396	3	_spiralling
spiring	10	39	1818	3	_spir__ing
spiting	10	39	1762	3	_spi__ting
spitting	11	30	1232	3	_spi_tting
sporting	11	24	1546	3	_spor_ting
spraying	14	29	988	3	_sp_raying
sprinting	12	3	1003	3	_sprinting
spurting	11	31	1163	3	_spur_ting
striating	10	9	1419	3	_striating
supinating	13	5	783	3	supinating
uprating	11	3	1111	3	_up_rating

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	79	5.610	25062.9
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	6.062	29477.2