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

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

74 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
fascitis	13	4	601	(None)
fasciitis	14	4	354	1	fasciitis
ascites	9	3	1260	2	_ascites
ascitic	11	3	932	2	_ascitic
fascias	12	5	841	2	fasci_as
fascines	13	3	1014	2	fascines
fascisms	15	4	566	2	fascisms
fascistic	16	4	459	2	fascistic
fascists	13	3	661	2	fascists
fascitises	15	4	474	2	fascitises
mastitis	10	3	910	2	mastitis
ascaris	9	36	1332	3	_ascaris
ascesis	9	3	837	3	_ascesis
ascetic	11	3	1006	3	_ascetic
ascetics	12	4	707	3	_ascetics
ascidia	10	4	668	3	_ascidia
ascots	8	53	1251	3	_ascot_s
basicities	14	4	686	3	basicities
basmatis	12	4	734	3	basmatis
calcites	12	3	1300	3	calcites
calcitic	11	4	819	3	calcitic
carditis	11	3	1022	3	carditis
casitas	9	33	1204	3	cas_itas
cystitis	13	4	571	3	cystitis
dacites	10	11	1459	3	da_cites
dashikis	16	4	367	3	dashikis
facets	11	63	1665	3	fa_cet_s
facials	12	33	1074	3	fa_cials
facias	11	34	1580	3	fa_ci_as
facies	11	39	2159	3	fa_ci_es
facings	13	45	1126	3	fa_cings
facts	10	70	2189	3	fa_c_t_s
faiths	12	46	1027	3	fa__iths
fajitas	17	3	425	3	fa_jitas
falsities	12	4	813	3	falsities
fanciers	13	35	808	3	fanciers
fancies	12	40	1878	3	fanci_es
fancifies	17	6	708	3	fancifies
farcies	12	53	1788	3	farci_es
fasces	11	49	1454	3	fasc__es
fascia	11	4	870	3	fasc__ia
fasciae	12	4	752	3	fasci_ae
fascial	12	5	830	3	fasci_al
fasciate	13	4	756	3	fasciate
fasciated	15	4	613	3	fasciated
fasciation	15	4	683	3	fasciation
fasciations	16	4	626	3	fasciations
fascicle	15	5	463	3	fascicle
fascicles	16	6	426	3	fascicles
fasciitises	16	5	256	3	fasciitises
fascinates	15	4	715	3	fascinates
fascine	12	5	1058	3	fasci_ne
fascism	14	3	644	3	fasci_sm
fascist	12	3	921	3	fasci_st
fashions	14	3	724	3	fashions
fashious	14	4	612	3	fashious
fastings	12	40	1194	3	fastings
fasts	8	64	2968	3	fas__t_s
fatuities	12	4	691	3	fatuities
faucets	12	57	844	3	faucet_s
gaseities	10	4	708	3	gaseities
gastritis	10	4	567	3	gastritis
mammitis	11	4	559	3	mammitis
mascots	11	39	1034	3	mascot_s
mastitic	12	4	826	3	mastitic
miscites	12	3	1378	3	miscites
pastis	8	49	2432	3	pas__tis
paucities	13	4	850	3	paucities
rachitis	13	4	835	3	rachitis
raucities	11	4	816	3	raucities
sashimis	13	4	375	3	sashimis
vasculitis	15	5	335	3	vasculitis
vastities	12	4	893	3	vastities
wapitis	12	3	647	3	wa_pitis

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	146162	0.483	369960.7
2	DLD Change Limit	146162	74	6.796	21507.1
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	7.312	24438.0