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

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

71 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
wastewaters	17	14	250	(None)
wastewater	16	14	300	1	wastewater_
wastepapers	18	5	161	2	wastepapers
anteaters	9	3	934	3	_ante_aters
bathwaters	18	4	353	3	ba_thwaters
castraters	12	4	647	3	cast_raters
tastemakers	17	5	251	3	tastemakers
wastepaper	17	5	182	3	wastepaper_
wasteways	18	4	311	3	wastewa__ys
anteater	8	3	1160	4	_ante_ater_
antedates	10	4	861	4	_antedate_s
asperates	11	3	1255	4	_asperate_s
assenters	9	6	699	4	_asse_nters
asserters	9	5	639	4	_asse_rters
attempters	14	4	266	4	_attempters
attesters	9	3	580	4	_atte_sters
backwaters	21	9	516	4	ba_ckwaters
bathwater	17	4	436	4	ba_thwater_
bilgewaters	17	7	165	4	bilgewaters
caseates	10	3	1371	4	cas_e_ate_s
casemates	13	4	952	4	cas_emate_s
castigates	13	4	755	4	castigate_s
castigators	14	4	554	4	castigators
castrater	11	4	852	4	cast_rater_
castrates	11	3	1267	4	cast_rate_s
castrators	12	4	744	4	cast_rators
catenates	11	3	1181	4	ca_tenate_s
cutwaters	14	4	361	4	_cut_waters
dewaters	12	29	1072	4	___dewaters
dishwaters	17	4	402	4	dis_hwaters
easterners	10	4	482	4	easte_rners
eyewaters	15	4	360	4	__eyewaters
fasteners	12	23	705	4	faste__ners
firewaters	16	4	432	4	_firewaters
hasteners	12	26	781	4	haste__ners
limewaters	15	4	352	4	_limewaters
maceraters	14	22	663	4	ma_ceraters
maltreaters	13	13	377	4	maltreaters
masseters	11	3	628	4	masse__ters
masticates	14	4	984	4	masticate_s
masticators	15	4	632	4	masticators
meltwaters	15	4	296	4	melt_waters
pastorates	12	4	1014	4	pastorate_s
rainwaters	13	4	372	4	ra_inwaters
ratemeters	12	4	499	4	ra_temeters
ratepayers	15	4	197	4	ra_tepayers
rosewater	12	4	502	4	ros_ewater_
saltwater	12	4	435	4	salt_water_
saturaters	10	4	556	4	sa_turaters
seaters	7	40	2894	4	__s_e_aters
seawaters	12	3	571	4	__seawaters
staters	7	39	2234	4	__st__aters
stealers	8	34	1220	4	__ste_alers
steamers	10	34	1087	4	__ste_amers
sweaters	11	38	1106	4	__swe_aters
tailwaters	13	4	351	4	ta_ilwaters
tastemaker	16	5	274	4	tastemaker_
tidewaters	14	4	346	4	_tidewaters
upstaters	11	17	480	4	upst__aters
wastages	12	10	975	4	wast__age_s
wastebaskets	21	6	69	4	wastebaskets
wastelands	14	4	289	4	wastela_nds
wastelots	12	10	403	4	wastelot__s
wasteries	12	11	1534	4	waste_rie_s
wasters	10	40	2659	4	was____ters
wasteway	17	4	331	4	wastewa___y
waterages	13	4	938	4	wa_terage_s
waterers	11	23	1278	4	wa_te__rers
wattmeters	15	4	360	4	wa_ttmeters
westerners	13	4	446	4	weste_rners
whitewashers	24	6	128	4	whitewashers

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.403	443402.0
2	DLD Change Limit	148819	71	9.283	16031.3
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	9.716	18391.4