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

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

63 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
chrysolites	19	5	309	(None)
chrysolite	18	5	344	1	chrysolite_
chrysalides	20	5	261	2	chrysalides
chrysalises	19	5	308	2	chrysalises
chrysotiles	19	15	242	2	chrysotiles
cryolites	14	4	696	2	c_ry_olites
chromites	16	3	1096	3	chr__omites
chrysalids	19	6	257	3	chrysali_ds
chrysalis	17	4	378	3	chrysali__s
chrysophytes	28	9	273	3	chrysophytes
chrysotile	18	14	262	3	chrysotile_
cryolite	13	4	750	3	c_ry_olite_
kryolites	16	4	399	3	_kry_olites
rhyolites	15	4	503	3	rh_y_olites
aerolites	9	3	1258	4	aer__olites
aerosolizes	20	5	356	4	aerosolizes
carbolizes	23	17	816	4	car_bolizes
carnallites	13	5	304	4	carnallites
carnotites	12	4	654	4	car_notites
catabolites	15	14	455	4	catabolites
cerusites	11	4	652	4	cerus__ites
cerussites	12	4	318	4	cerus_sites
chalcocites	17	5	254	4	chalcocites
chayotes	16	3	650	4	chay_o__tes
chlorites	14	23	1196	4	ch__lorites
chocolates	17	4	678	4	ch_ocolates
cholates	13	24	1476	4	ch___olates
cholines	13	22	1449	4	ch___olines
christies	14	4	926	4	chris_ti_es
chromates	16	3	1311	4	chr__omates
chromides	17	4	760	4	chr__omides
chromite	15	3	1083	4	chr__omite_
chromizes	25	4	760	4	chr__omizes
chrysalid	18	5	320	4	chrysali__d
chrysomelids	23	6	132	4	chrysomeli_ds
chrysophyte	27	10	270	4	chrysophyte_
chrysoprase	21	6	182	4	chrysoprase
chrysoprases	22	6	201	4	chrysoprases
coprolites	14	4	822	4	c_oprolites
corydalises	17	5	335	4	corydalises
creolises	11	5	789	4	c_r_eolises
creolizes	20	5	658	4	c_r_eolizes
crinolines	12	4	673	4	c_rinolines
crocoites	13	4	746	4	c_roco_ites
crystalizes	25	14	578	4	c_rystalizes
crystallites	17	14	390	4	c_rystallites
cystoliths	18	5	289	4	c__ystoliths
hessonites	13	4	369	4	_hessonites
hyalites	14	20	883	4	_h_y_alites
ichnolites	15	4	404	4	ich__nolites
kryolite	15	4	449	4	_kry_olite_
kryoliths	19	4	223	4	_kry_oliths
phonolites	15	4	765	4	ph_onolites
phyllites	17	4	532	4	ph_y_llites
phytoliths	21	6	347	4	ph_ytoliths
pisolites	11	4	938	4	__pisolites
resolutes	9	6	819	4	__resolutes
rhodolites	14	4	437	4	rh_odolites
rhyolite	14	4	551	4	rh_y_olite_
stylolites	13	4	365	4	_stylolites
theodolites	15	5	314	4	theodolites
tremolites	12	5	605	4	_tremolites
variolites	13	4	667	4	var_iolites

Search took 9 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.420	425454.8
2	DLD Change Limit	148819	63	8.033	18526.0
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	8.483	21064.6