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

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

67 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
fayalites	15	4	606	(None)
fayalite	14	4	705	1	fayalite_
fatalities	13	4	944	2	fatalities
hyalites	14	20	883	2	_hyalites
analcites	11	4	748	3	_analcites
analities	9	7	1587	3	_analities
analytes	11	16	920	3	_analytes
apatites	10	3	1129	3	_apatites
aplites	9	3	1493	3	_a_plites
bakelites	15	4	599	3	bakelites
banalities	12	4	981	3	banalities
banalizes	20	12	1009	3	banalizes
basaltes	10	36	768	3	basal_tes
calamites	13	4	1071	3	calamites
canalises	11	5	1549	3	canalises
canalizes	20	11	1378	3	canalizes
catamites	13	4	936	3	catamites
cryolites	14	4	696	3	cryolites
cyanites	13	26	1016	3	_cyanites
dayflies	15	3	446	3	dayfli_es
egalites	9	3	1050	3	_egalites
fabulates	14	4	773	3	fabulates
facilities	15	4	982	3	facilities
faculties	14	5	514	3	faculties
families	13	3	944	3	famili_es
faradises	13	24	898	3	faradises
faradizes	22	23	744	3	faradizes
farolitos	12	4	405	3	farolitos
fatalisms	14	3	911	3	fatalisms
fatalists	12	3	1002	3	fatalists
fatality	14	3	844	3	fatalit_y
favorites	15	4	658	3	favorites
fealties	11	3	999	3	f_ealties
finalises	12	29	1152	3	finalises
finalities	13	4	990	3	finalities
finalizes	21	28	1074	3	finalizes
fleabites	14	4	361	3	fleabites
flites	9	51	2244	3	f___lites
focalises	14	13	995	3	focalises
focalizes	23	15	932	3	focalizes
halites	10	32	2119	3	__halites
haplites	13	3	999	3	ha_plites
hyalines	14	16	933	3	_hyalines
hyalite	13	22	947	3	_hyalite_
kamacites	17	4	452	3	kamacites
kryolites	16	4	399	3	kryolites
kyanites	15	21	668	3	_kyanites
lazulites	18	4	425	3	lazulites
localites	11	12	1043	3	localites
loyalties	12	4	448	3	loyalties
marlites	10	34	1526	3	ma_rlites
mayflies	16	4	491	3	mayfli_es
nasalises	9	4	811	3	nasalises
nasalities	10	4	856	3	nasalities
nasalizes	18	4	723	3	nasalizes
natalities	10	4	1066	3	natalities
parakites	15	4	954	3	parakites
parasites	11	3	1315	3	parasites
phyllites	17	4	532	3	phyllites
rhyolites	15	4	503	3	rhyolites
royalties	12	4	491	3	royalties
ruralites	9	4	794	3	ruralites
sodalites	10	12	869	3	sodalites
stylites	11	16	869	3	sty_lites
tantalites	10	9	928	3	tantalites
uralites	8	21	1272	3	_uralites
zaratites	18	4	700	3	zaratites

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	148641	0.440	406115.9
2	DLD Change Limit	148641	67	6.140	24208.6
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	6.610	27033.4