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

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

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
graptolites	14	5	297	(None)
graptolite	13	5	337	1	graptolite_
granoliths	14	4	330	3	gra_noliths
granulites	11	4	662	3	gra_nulites
graphites	15	4	682	3	grap__hites
graplines	12	3	735	3	grap__lines
gratulates	11	5	713	3	gra_tulates
saprolites	12	4	705	3	_saprolites
scapolites	14	5	569	3	scap_olites
aerolites	9	3	1258	4	__aerolites
apholates	14	4	968	4	__apholates
aplites	9	3	1493	4	__ap__lites
aragonites	11	4	580	4	ara_gonites
coprolites	14	4	822	4	_coprolites
cryolites	14	4	696	4	cr__yolites
diatomites	13	4	536	4	dia_tomites
evaporites	15	4	465	4	evap_orites
gantlines	10	3	933	4	g_ant_lines
gaposises	12	4	552	4	g_ap_osises
gasolines	10	4	748	4	g_a_solines
gastroliths	15	5	244	4	g_astroliths
glauconites	14	9	261	4	glauconites
gnathites	13	4	423	4	gna_t_hites
gracilities	14	4	768	4	gra_cilities
granites	9	21	1636	4	gra___nites
granolith	13	4	527	4	gra_nolit_h
granulates	11	4	846	4	gra_nulates
granulite	10	4	692	4	gra_nulite_
grapelike	16	4	466	4	grap_elike_
graperies	12	3	961	4	grap_eri_es
grapevines	16	4	290	4	grap_evines
graphite	14	4	715	4	grap__hite_
graphitizes	26	5	272	4	graphitizes
grapholects	19	5	173	4	grapholects
graphologies	19	6	373	4	graphologies
grapline	11	3	872	4	grap__line_
graplins	11	4	826	4	grap__li_ns
grapples	13	34	812	4	grap_pl__es
grapplings	16	4	232	4	grap_plings
gratifies	13	4	799	4	gra_tifi_es
gratuities	11	4	531	4	gra_t_uities
gratulate	10	4	768	4	gra_tulate_
gratulated	12	5	573	4	gra_tulated
gravesites	14	4	394	4	gra_vesites
haplites	13	3	999	4	_hap__lites
kryolites	16	4	399	4	kr__yolites
natrolites	10	4	742	4	_natrolites
oratories	9	4	1065	4	ora_tori_es
propolises	14	4	885	4	prop_olises
propylites	17	4	630	4	prop_ylites
ratites	7	49	2068	4	_ra_t__ites
ratlines	8	38	1529	4	_ra_t_lines
rhodolites	14	4	437	4	_rhodolites
rhyolites	15	4	503	4	_r_hyolites
saponites	11	3	994	4	_sap_onites
saprolite	11	4	783	4	_saprolite_
scapolite	13	4	624	4	scap_olite_
sepiolites	12	4	601	4	_sepiolites
statoliths	13	5	345	4	sta_toliths
staurolites	11	5	259	4	staurolites
tantalites	10	9	928	4	_tantalites
trampolines	15	4	390	4	trampolines
traplines	11	3	1037	4	trap__lines
tremolites	12	5	605	4	tr_emolites
triplites	11	4	828	4	trip__lites
uralites	8	21	1272	4	ura___lites
variolites	13	4	667	4	_variolites

Search took 10 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	148819	0.470	380193.6
2	DLD Change Limit	148819	67	9.140	16282.2
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	9.640	18536.4