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

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

67 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
phalansteries	18	6	201	(None)
phalanstery	19	5	138	3	phalanster__y
phylacteries	22	7	333	3	phyla_cteries
allosteries	11	5	539	4	__allosteries
characteries	19	7	496	4	chara_cteries
palmistries	15	9	376	4	p_almist_ries
peasantries	13	5	341	4	peasan_t_ries
phalangers	16	7	376	4	phalan_ger__s
philatelies	16	5	327	4	phila__telies
planetaries	13	4	594	4	p__lanetaries
psalteries	12	7	656	4	psal___teries
upholsteries	17	5	246	4	uphol__steries
baptisteries	16	5	239	5	_baptisteries
chanceries	17	4	765	5	ch__an_ceries
chandleries	17	4	433	5	ch__andleries
chantries	14	3	1029	5	ch__an_t_ries
characterizes	29	6	285	5	chara_cterizes
charcuteries	19	9	315	5	cha_rcuteries
chicaneries	18	5	391	5	chican__eries
flaneries	12	4	956	5	__flan__eries
flatteries	13	4	741	5	__fla_tteries
gallantries	12	5	411	5	gallan_t_ries
halteres	11	34	1459	5	_hal___ter_es
lamaseries	12	4	489	5	_lama_s_eries
masteries	11	10	1849	5	___ma_steries
monasteries	13	4	594	5	_mona_steries
pageantries	14	5	298	5	pagean_t_ries
palaestrae	12	5	234	5	p_alaest_rae_
palaestras	12	5	264	5	p_alaest_r_as
palmisters	14	4	467	5	p_almister__s
pantries	10	18	1739	5	p___an_t_ries
papeteries	14	4	655	5	p___apeteries
papistries	14	4	519	5	p_a_pist_ries
parameterizes	26	15	301	5	p_arameterizes
pastries	10	15	1742	5	p___a_st_ries
patisseries	13	5	290	5	p_a_tisseries
pedantries	13	4	568	5	p_edan_t_ries
phalanger	15	5	411	5	phalan_ger___
phalanges	15	6	536	5	phalan____ges
phalanxes	21	5	391	5	phalan____xes
phantasies	15	4	548	5	ph__an_tasies
philandered	18	5	224	5	philan_der_ed
philanderer	17	5	209	5	philan_der_er
philanderers	18	5	167	5	philan_derers
philandering	19	6	257	5	philan_dering
philanders	16	4	427	5	philan_der__s
philanthropies	24	9	253	5	philan_thropies
phratries	14	4	758	5	ph_ra__t_ries
pilasters	11	3	822	5	p_ila_ster__s
plaistered	13	4	413	5	p__laister_ed
plaistering	14	4	460	5	p__laistering
plaisters	11	3	781	5	p__laister__s
plankters	15	4	458	5	p__lankter__s
planters	10	29	1532	5	p__lan_ter__s
plastered	12	8	889	5	p__la_ster_ed
plasterer	11	7	810	5	p__la_ster_er
plasterers	12	8	612	5	p__la_sterers
plastering	13	3	924	5	p__la_stering
plasterings	14	4	474	5	p__la_sterings
plasters	10	35	1813	5	p__la_ster__s
pleasantries	14	5	178	5	pleasan_t_ries
printeries	12	4	1063	5	p__rin_teries
psaltries	11	8	574	5	psal___t_ries
thalassaemias	18	7	116	5	thalassaemias
thalassemias	17	6	153	5	thala_ssemias
thalassemics	19	6	125	5	thala_ssemics
wasteries	12	11	1534	5	___wa_steries

Search took 9 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	67	7.796	16006.9
3	Display Results	67	67	0.033	2030.3
	(SQL Overall)	178691	67	8.219	21741.2