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

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

56 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
urbanologist	15	5	404	(None)
urbanologists	16	5	325	1	urbanologists
urbanologies	15	5	296	2	urbanologies
oceanologist	15	5	568	3	oceanologist
uranologies	12	4	613	3	ur_anologies
urbanology	16	5	251	3	urbanolog__y
urologist	10	4	1105	3	ur___ologist
vulcanologist	19	8	270	3	vulcanologist
analogist	10	4	1023	4	___analogist
apologist	12	4	1240	4	___apologist
archaeologist	19	11	349	4	archaeologist
biologist	12	4	1234	4	__b_iologist
bryologist	16	4	738	4	__bryologist
campanologist	20	5	338	4	campanologist
chronologist	18	5	762	4	chronologist
criminologist	18	6	364	4	criminologist
cryptologist	20	5	643	4	cryptologist
demonologist	16	5	705	4	demonologist
dermatologist	17	8	646	4	dermatologist
embryologist	20	5	387	4	embryologist
enologist	10	3	1412	4	___enologist
escapologist	17	5	448	4	escapologist
ethnologist	15	4	926	4	_ethnologist
graphologist	19	11	486	4	graphologist
hematologist	18	21	920	4	hematologist
immunologist	17	13	532	4	immunologist
iridologist	13	4	579	4	ir_idologist
limnologist	14	4	668	4	_limnologist
malacologist	17	5	563	4	malacologist
monologist	13	4	1361	4	__monologist
narratologist	14	5	383	4	narratologist
nematologist	15	20	847	4	nematologist
oceanologists	16	5	430	4	oceanologists
organologies	14	5	408	4	organologies
orologist	10	3	1310	4	or___ologist
palynologist	18	5	630	4	palynologist
penologist	13	4	1284	4	__penologist
phonologist	17	4	1156	4	_phonologist
phrenologist	18	5	791	4	phrenologist
primatologist	18	17	531	4	primatologist
proctologist	17	5	896	4	proctologist
prologist	12	3	1508	4	pr___ologist
radiologist	13	9	949	4	_radiologist
rheologist	14	4	953	4	_r_heologist
selenologist	13	5	700	4	selenologist
sinologist	11	5	1066	4	__sinologist
technologist	18	13	740	4	technologist
teratologist	13	10	857	4	teratologist
tribologist	14	4	772	4	tr_ibologist
trichologist	18	5	674	4	trichologist
ufologist	13	4	705	4	u___fologist
uranology	13	4	489	4	ur_anolog__y
urbanist	10	10	907	4	urban____ist
urologists	11	4	841	4	ur___ologists
volcanologist	19	9	316	4	volcanologist
vulcanologists	20	9	230	4	vulcanologists

Search took 7 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.410	435831.7
2	DLD Change Limit	124790	56	6.466	19299.4
3	Display Results	56	56	0.046	1217.4
	(SQL Overall)	178691	56	6.922	25814.9