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

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

75 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
sanitariums	13	5	343	(None)
sanitarium	12	5	462	1	sanitarium_
sanitoriums	13	5	303	1	sanitoriums
sanatoriums	13	5	352	2	sanatoriums
sanitarians	11	4	624	2	sanitarians
sanitaries	10	4	991	2	sanitari_es
sanitorium	12	5	473	2	sanitorium_
planetariums	16	7	185	3	planetariums
samariums	13	4	513	3	sa__mariums
sanatorium	12	4	533	3	sanatorium_
sanitaria	9	4	706	3	sanitari__a
sanitarian	10	4	744	3	sanitari_an
sanitarily	13	10	447	3	sanitari_ly
sanitations	11	4	1084	3	sanitations
animalisms	14	5	743	4	_animalisms
animatisms	14	4	663	4	_animatisms
anthuriums	15	5	327	4	_anthuriums
antiarins	9	4	1389	4	_antiari_ns
antrums	9	6	917	4	_an_t_r_ums
aquariums	20	4	395	4	_a_quariums
atriums	9	3	904	4	_a__t_riums
auditoriums	14	5	193	4	auditoriums
cafetoriums	18	5	227	4	cafetoriums
calvariums	17	4	326	4	ca_lvariums
capitalisms	17	6	550	4	capitalisms
criteriums	14	4	438	4	_criteriums
dentaliums	13	4	374	4	den_taliums
honorariums	16	5	220	4	honorariums
janisaries	17	4	478	4	janisari_es
janizaries	26	4	350	4	janizari_es
laniaries	9	4	1122	4	lani_ari_es
magisteriums	17	5	146	4	magisteriums
manubriums	16	5	207	4	man_ubriums
militarisms	15	5	598	4	militarisms
monetarisms	15	5	502	4	monetarisms
natatoriums	13	8	268	4	natatoriums
natriums	10	4	629	4	__nat_riums
pancratiums	17	6	210	4	pancratiums
pastoriums	14	4	555	4	pa_storiums
planetarium	15	6	285	4	planetarium_
sacrarium	13	4	447	4	sa_crarium_
sagittaries	12	5	299	4	sagittari_es
samarium	12	5	728	4	sa__marium_
sanctuaries	13	5	336	4	sanctuari_es
sanctums	12	4	401	4	sanct___ums
sanitary	11	4	675	4	sanitar___y
sanitates	9	6	1173	4	sanita__tes
sanitating	11	4	965	4	sanitati_ng
sanitation	10	4	1204	4	sanitati_on
sanities	8	12	1977	4	sanit__i_es
sanitises	9	11	1174	4	sanit__ises
sanitizes	18	12	1013	4	sanit__izes
sanitoria	9	4	667	4	sanitori__a
santerias	9	3	1184	4	san_teri_as
santims	9	3	1260	4	san_t__i_ms
sartorius	9	4	716	4	sa_rtoriu_s
satanisms	11	4	814	4	sa__tanisms
senarius	8	3	1010	4	sen__ariu_s
sensoriums	12	4	365	4	sen_soriums
septarium	13	4	516	4	s_eptarium_
sextarius	16	4	421	4	s_extariu_s
sitarists	9	4	937	4	s__itarists
solariums	11	6	592	4	s__olariums
solidarisms	14	5	350	4	solidarisms
solitaries	10	4	1012	4	solitari_es
stadiums	11	4	570	4	s___tadiums
sudatoriums	14	5	238	4	sudatoriums
tantalums	11	4	310	4	tan_ta_lums
tantrisms	11	4	632	4	tan_t_risms
tantrums	10	4	511	4	tan_t_r_ums
titaniums	11	4	476	4	__titaniums
unitarians	10	4	608	4	_unitarians
vanadiums	15	4	322	4	van__adiums
vanitories	13	4	691	4	vanitori_es
vivariums	17	4	296	4	__vivariums

Search took 10 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.436	409841.7
2	DLD Change Limit	148819	75	8.876	16766.4
3	Display Results	75	75	0.046	1630.4
	(SQL Overall)	178691	75	9.358	19095.0