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

Here are the results of your fuzzy-string dictionary search for “observatories” with Change Limit: [1] [2] [3] [4] [5] [6]

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.

57 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
observatories	18	6	167	(None)
conservatories	19	6	254	2	conservatories
conservatoires	19	6	218	3	conservatoires
observatory	19	5	260	3	observator__y
conservatoire	18	6	276	4	conservatoire_
conservatorial	19	7	224	4	conservatorial
conservators	17	5	597	4	conservator__s
observables	18	5	200	4	observa__bles
observances	18	11	382	4	observa__nces
observation	16	6	505	4	observat__ion
observations	17	8	501	4	observat_ions
offertories	17	5	265	4	offer__tories
oratories	9	4	1064	4	o___r_atories
overstories	14	4	714	4	o_ver_stories
barratries	12	4	573	5	_b_arrat_ries
clerestories	14	5	331	5	_clerestories
conservancies	20	5	410	5	conserva_ncies
conservatives	21	9	519	5	conservat_ives
conservatizes	27	11	445	5	conservat_izes
conservator	16	5	636	5	conservator___
conservatory	20	5	475	5	conservator__y
cosignatories	16	6	121	5	cosignatories
crematories	15	4	685	5	_cre_matories
dispensatories	17	6	98	5	dispensatories
enervators	13	4	570	5	_enervator__s
feretories	13	4	860	5	__fer_etories
feudatories	15	5	371	5	__feudatories
herstories	13	4	860	5	__her_stories
laboratories	14	8	231	5	labor_atories
lavatories	13	4	503	5	___lavatories
levatores	12	22	573	5	__le_vator_es
masticatories	17	6	219	5	masticatories
nervatures	13	6	352	5	__nervatur_es
obsecrates	14	4	458	5	obsecrat___es
observabilities	22	9	374	5	observabilities
observability	23	5	348	5	observability
observable	17	4	333	5	observa__ble_
observance	17	12	403	5	observa__nce_
observants	15	5	335	5	observa___nts
observational	18	5	317	5	observational
observers	14	4	396	5	observ__er__s
observes	13	4	616	5	observ_____es
obstructors	15	6	400	5	obstructor__s
obturators	12	4	430	5	obtur_ator__s
operatorless	14	6	189	5	o_per_atorless
operators	11	4	1075	5	o_per_ator__s
oratorios	9	4	492	5	o___r_atorios
purgatories	14	6	333	5	__purgatories
reformatories	18	6	255	5	reformatories
repertories	13	5	583	5	reper__tories
secretories	13	4	594	5	__secretories
serratures	10	4	486	5	__serratur_es
servitors	12	4	520	5	__servitor__s
signatories	12	5	363	5	__signatories
sudatories	11	4	567	5	__s_udatories
territories	11	4	601	5	__territories
understories	13	6	556	5	under_stories

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	124790	0.140	1276364.3
2	DLD Change Limit	124790	57	9.436	13224.9
3	Display Results	57	57	0.046	1239.1
	(SQL Overall)	178691	57	9.622	18571.1