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

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

78 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
cerusites	11	4	652	(None)
cerusite	10	4	776	1	cerusite_
cerussites	12	4	318	1	cerussites
cerastes	10	11	1109	2	ceras_tes
cerites	9	48	2343	2	cer__ites
ceruses	9	37	1623	2	cerus__es
cerussite	11	4	401	2	cerussite_
crudites	11	3	776	2	c_rudites
aerolites	9	3	1258	3	aerolites
campsites	15	4	647	3	campsites
celestes	10	3	1001	3	celes_tes
celestites	12	12	596	3	celestites
cellulites	12	9	443	3	cellulites
cenobites	13	4	620	3	cenobites
ceramides	14	4	745	3	ceramides
cerates	9	54	2825	3	cer__ates
cercises	12	4	1093	3	cer_cises
cereuses	10	4	924	3	cereus__es
cerises	9	47	2225	3	cer__ises
cerite	8	47	2487	3	cer__ite_
certes	8	46	2308	3	cer___tes
ceruse	8	39	1452	3	cerus__e_
cervices	15	3	713	3	cer_vices
cervixes	20	5	460	3	cer_vixes
christies	14	4	927	3	christies
chromites	16	3	1096	3	chromites
clerisies	11	4	725	3	clerisi_es
coesites	10	13	1309	3	c_oesites
cordites	11	3	1463	3	cor_dites
coruscates	14	4	569	3	coruscates
creosotes	11	4	565	3	creosotes
crinites	10	6	1276	3	c_rinites
crudities	12	4	774	3	c_rudities
cruises	9	35	1444	3	c_ru_ises
crusades	11	4	633	3	c_rusades
cruses	8	81	2771	3	c_rus__es
crusets	9	38	1104	3	c_ruset_s
crushes	12	42	1513	3	c_rus_hes
crusted	10	37	1276	3	c_rus_ted
crustier	10	25	953	3	c_rustier
crustiest	11	24	1005	3	c_rustiest
crusts	8	49	1654	3	c_rus_t_s
curbsides	14	4	448	3	curbsides
curites	9	39	1986	3	c__urites
cursives	13	3	710	3	cur_sives
curtsies	10	3	873	3	curtsi_es
equites	16	22	1249	3	_equ_ites
eremites	10	3	1260	3	_eremites
erudite	8	3	848	3	_erudite_
felsites	11	3	807	3	fe_lsites
ferrites	11	23	1283	3	fer_rites
heresies	11	3	1270	3	heresi_es
hessites	11	3	861	3	he_ssites
jarosites	16	4	737	3	jarosites
kernites	12	6	911	3	ker_nites
kerosines	13	5	711	3	kerosines
leucites	10	3	733	3	le_ucites
lewisites	12	4	421	3	lewisites
parasites	11	3	1315	3	parasites
perfusates	15	4	399	3	perfusates
perlites	10	3	1636	3	per_lites
perquisites	22	5	281	3	perquisites
peruses	9	40	1816	3	perus__es
preunites	11	3	893	3	preunites
requisites	19	6	450	3	requisites
requites	17	15	1176	3	requ_ites
resites	7	40	2779	3	__resites
reunites	8	3	1247	3	re_unites
serosities	10	4	1082	3	serosities
tergites	9	3	1054	3	ter_gites
termites	10	3	1369	3	ter_mites
trusties	8	27	1285	3	_trusties
verites	10	38	2226	3	ver__ites
versines	11	22	1382	3	ver_sines
verstes	10	40	1428	3	ver_s_tes
websites	13	3	518	3	we_bsites
wellsites	12	4	467	3	wellsites
xeruses	14	30	1075	3	xerus__es

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	148641	0.406	440125.6
2	DLD Change Limit	148641	78	6.940	21418.0
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.376	24226.0