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

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

68 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
physiologist	21	15	732	(None)
physiologists	22	15	601	1	physiologists
phycologist	22	5	918	2	phy_cologist
physiologic	22	5	471	2	physiologi_c
physiologies	21	5	536	2	physiologies
histologist	15	4	798	3	_histologist
hydrologist	19	4	833	3	_hydrologist
philologist	17	6	843	3	ph_ilologist
phonologist	17	4	1156	3	ph_onologist
phraseologist	19	5	419	3	phraseologist
phrenologist	18	5	791	3	phrenologist
phycologists	23	6	713	3	phy_cologists
physiological	24	5	557	3	physiological
physiology	22	5	444	3	physiolog__y
psychologist	23	10	911	3	psychologist
audiologist	13	4	724	4	_audiologist
biologist	12	4	1234	4	___biologist
bryologist	16	4	738	4	bry__ologist
cardiologist	16	5	662	4	cardiologist
chronologist	18	5	762	4	chronologist
cosmologist	16	4	837	4	_cosmologist
cryobiologist	21	5	452	4	cryobiologist
cryptologist	20	5	643	4	cryptologist
cytologist	16	4	1053	4	_cy_tologist
etymologist	17	15	802	4	ety_mologist
exobiologist	22	5	620	4	exobiologist
glaciologist	16	5	489	4	glaciologist
histologists	16	4	629	4	_histologists
horologist	14	4	1236	4	_h_orologist
hydrologists	20	4	609	4	_hydrologists
museologist	14	4	580	4	_museologist
musicologist	17	5	428	4	_musicologist
mycologist	18	4	1035	4	_my_cologist
myologist	15	4	1109	4	_my__ologist
mythologist	20	5	899	4	_mythologist
nonbiologist	15	5	591	4	nonbiologist
palynologist	18	5	630	4	palynologist
papyrologist	20	5	509	4	papyrologist
parasitologist	17	6	325	4	parasitologist
pathologist	17	4	1066	4	p_athologist
pedologist	14	4	1086	4	p__edologist
penologist	13	4	1284	4	p__enologist
petrologist	14	7	1188	4	p_etrologist
philologists	18	7	668	4	ph_ilologists
phonologists	18	4	877	4	ph_onologists
photobiologist	22	6	622	4	photobiologist
phraseologists	20	5	357	4	phraseologists
phrenologists	19	5	629	4	phrenologists
phycologies	22	4	778	4	phy_cologies
physiatrist	19	8	312	4	physi_atrist
physicalist	21	5	387	4	physi_calist
physicist	19	5	518	4	physi___cist
phytologies	20	4	904	4	phy_tologies
pomologist	15	4	1204	4	p__omologist
proctologist	17	5	896	4	proctologist
prologist	12	3	1508	4	p___rologist
psephologist	20	5	660	4	psephologist
psychologise	23	10	704	4	psychologise
psychologism	25	12	605	4	psychologism
psychologists	24	12	747	4	psychologists
pteridologist	17	14	460	4	pteridologist
radiologist	13	9	949	4	_radiologist
rheologist	14	4	953	4	rh__eologist
seismologist	15	12	527	4	seismologist
semiologist	14	4	1071	4	_semiologist
sinologist	11	5	1066	4	___sinologist
sociologist	14	4	988	4	_sociologist
typologist	16	4	889	4	_ty_pologist

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	124790	0.390	458182.1
2	DLD Change Limit	124790	68	6.906	18069.8
3	Display Results	68	68	0.046	1478.3
	(SQL Overall)	178691	68	7.342	24338.2