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

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

54 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
dermatologist	17	8	646	(None)
dermatologists	18	13	492	1	dermatologists
dermatologic	18	5	449	2	dermatologi_c
dermatologies	17	5	525	2	dermatologies
hematologist	18	21	920	2	he_matologist
nematologist	15	20	847	2	ne_matologist
teratologist	13	10	857	2	ter_atologist
climatologist	18	7	394	3	climatologist
demonologist	16	5	705	3	de_monologist
deontologist	14	5	741	3	de_ontologist
dermatological	20	5	385	3	dermatological
dermatology	18	5	392	3	dermatolog__y
gerontologist	15	5	598	3	gerontologist
hematologists	19	21	705	3	he_matologists
herpetologist	19	8	479	3	herpetologist
narratologist	14	5	383	3	narratologist
nematologists	16	16	660	3	ne_matologists
neonatologist	14	13	535	3	neonatologist
onomatologist	16	5	440	3	onomatologist
primatologist	18	17	531	3	primatologist
rheumatologist	20	6	285	3	rheumatologist
teratologists	14	9	659	3	ter_atologists
cetologist	13	4	1225	4	ce___tologist
climatologists	19	8	328	4	climatologists
cosmetologist	18	5	397	4	cosmetologist
cryptologist	20	5	643	4	_cryptologist
demonologists	17	5	556	4	de_monologists
dendrologist	15	5	509	4	de_ndrologist
deontologists	15	5	592	4	de_ontologists
dermatosis	13	5	493	4	dermat__osis_
diabetologist	17	13	314	4	diabetologist
escapologist	17	5	448	4	_escapologist
fetologist	14	4	1040	4	fe___tologist
gemmologist	17	4	654	4	ge_m_mologist
gemologist	14	10	1028	4	ge_m__ologist
gerontologists	16	5	485	4	gerontologists
hematologic	19	5	635	4	he_matologi_c
hematologies	18	4	756	4	he_matologies
herpetologists	20	8	363	4	herpetologists
myrmecologist	23	5	331	4	myrmecologist
narratologists	15	5	321	4	narratologists
nematologies	15	4	669	4	ne_matologies
neonatologists	15	8	419	4	neonatologists
onomatologists	17	5	333	4	onomatologists
pharmacologist	24	6	417	4	pharmacologist
primatologists	19	18	435	4	primatologists
proctologist	17	5	896	4	_proctologist
rheumatologists	21	6	225	4	rheumatologists
semiologist	14	4	1071	4	se_m_iologist
serologist	11	4	1315	4	ser___ologist
teratologic	14	5	565	4	ter_atologi_c
teratologies	13	4	687	4	ter_atologies
thanatologist	17	5	361	4	thanatologist
urbanologist	15	5	404	4	_urbanologist

Search took 6 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	95024	0.390	458182.1
2	DLD Change Limit	95024	54	5.436	17480.5
3	Display Results	54	54	0.046	1173.9
	(SQL Overall)	178691	54	5.872	30431.0