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

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

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.

63 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
wisterias	12	4	810	(None)
listerias	9	5	923	1	listerias
wistarias	12	4	679	1	wistarias
wisteria	11	4	775	1	wisteria_
asterias	8	3	1701	2	_asterias
hysterias	15	4	715	2	hysterias
listeria	8	3	943	2	listeria_
wasteries	12	11	1534	2	wasteries
wistaria	11	4	662	2	wistaria_
asteria	7	3	1618	3	_asteria_
bacterias	13	4	928	3	bacterias
bisters	9	39	2261	3	bister__s
cisterna	10	37	636	3	cisterna_
cisternae	11	26	509	3	cisternae
cisternal	11	32	574	3	cisternal
cisterns	10	36	957	3	cister_ns
disherits	13	4	823	3	disherits
fisheries	15	4	864	3	fisheries
hatterias	12	5	874	3	hatterias
historian	12	12	810	3	historian
historians	13	10	630	3	historians
histories	12	4	1247	3	histories
hysteria	14	4	739	3	hysteria_
hysterics	17	4	605	3	hysterics
icterics	12	4	705	3	_icterics
interims	10	10	1307	3	_interims
listers	7	40	2653	3	lister__s
masteries	11	10	1849	3	masteries
miseries	10	3	2040	3	mis_eries
misterms	12	37	1135	3	mister_ms
misters	9	39	2751	3	mister__s
mistrial	10	3	1138	3	mist_rial
mistrials	11	4	813	3	mist_rials
mysteries	14	12	1119	3	mysteries
niteries	8	3	1838	3	ni_teries
pizzerias	19	4	216	3	pizzerias
ristras	7	3	1156	3	rist_r_as
santerias	9	3	1184	3	santerias
sistering	10	12	1375	3	sistering
sisters	7	37	2159	3	sister__s
twisters	11	26	817	3	twister__s
victorias	14	4	652	3	victorias
waisters	11	38	1152	3	waister__s
washaterias	17	8	224	3	washaterias
washeterias	17	6	188	3	washeterias
wasterie	11	12	1158	3	wasteri_e
wasters	10	40	2659	3	waster__s
wastries	11	12	1288	3	wast_ries
westering	13	21	1264	3	westering
westerlies	13	4	561	3	westerlies
westerns	11	32	896	3	wester_ns
westers	10	52	2196	3	wester__s
wiggeries	14	13	657	3	wiggeries
wineries	11	23	1653	3	wi_neries
winterers	12	20	972	3	winterers
winterier	12	3	833	3	winterier
winteriest	13	4	881	3	winteriest
wintering	13	4	1236	3	wintering
winterish	15	4	664	3	winterish
winterize	21	4	692	3	winterize
winterizes	22	4	714	3	winterizes
winters	10	37	2048	3	winter__s
wishers	13	32	1521	3	wisher__s

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	148641	0.406	440125.6
2	DLD Change Limit	148641	63	6.876	21617.4
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	7.312	24438.0