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

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

76 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
waterpowers	19	5	351	(None)
waterpower	18	5	408	1	waterpower_
warpowers	17	4	455	2	wa__rpowers
waterfowlers	21	5	211	2	waterfowlers
airpowers	14	4	347	3	_a_irpowers
interposers	13	4	626	3	interposers
overpowers	18	4	472	3	_overpowers
superpowers	18	9	480	3	superpowers
warpower	16	4	504	3	wa__rpower_
watchtowers	22	7	147	3	watchtowers
watercolors	16	5	296	3	watercolors
watercoolers	17	5	253	3	watercoolers
waterers	11	23	1278	3	water___ers
waterfowler	20	5	230	3	waterfowler_
waterfowls	19	5	333	3	waterfow_ls
waterproofers	21	15	199	3	waterproofers
airpower	13	4	398	4	_a_irpower_
caterers	10	28	1440	4	cater___ers
counterpowers	20	6	482	4	counterpowers
empowers	15	27	684	4	___empowers
firepowers	18	12	298	4	fire_powers
harrowers	15	5	568	4	ha__rrowers
interlopers	13	4	619	4	interlopers
interposer	12	4	811	4	interposer_
interposes	12	4	1056	4	interpose_s
latecomers	14	4	282	4	late_comers
manpowers	16	4	446	4	ma__npowers
outpowers	14	4	519	4	out__powers
overpower	17	4	623	4	_overpower_
paternosters	14	5	173	4	paternosters
ratepayers	15	4	197	4	rate_payers
repowers	13	28	853	4	__re_powers
superpower	17	8	545	4	superpower_
throwers	14	10	603	4	__thr_owers
wagerers	12	24	761	4	wager___ers
wallflowers	20	5	240	4	wallflowers
wallowers	15	12	765	4	wa__llowers
warpers	12	34	1358	4	wa__rp__ers
wastepapers	18	5	161	4	waste_papers
watchtower	21	7	174	4	watchtower_
waterages	13	4	938	4	water_age_s
waterbeds	15	4	488	4	water__beds
waterbuses	15	4	494	4	waterbuse_s
watercolor	15	5	286	4	watercolor_
watercooler	16	5	301	4	watercooler_
watercourse	16	10	238	4	waterco_urse
watercress	15	4	338	4	water_cress
waterdogs	14	4	455	4	waterdo__gs
waterer	10	33	1407	4	water___er_
waterfowl	18	4	347	4	waterfow__l
waterhens	15	7	496	4	water__hens
waterier	11	3	1208	4	water__ier_
wateriness	13	4	807	4	water_iness
waterjets	19	4	446	4	water__jets
waterless	12	3	801	4	water__less
waterlines	13	4	895	4	waterline_s
waterlogs	13	4	538	4	waterlo__gs
waterloos	12	4	604	4	waterlo__os
waterproofer	20	18	250	4	waterproofer_
waterproofs	19	5	301	4	waterproofs
watersheds	17	4	353	4	water_sheds
watersides	14	4	553	4	waterside_s
waterspouts	16	5	186	4	waterspo_uts
waterways	18	4	509	4	water__ways
waterweed	16	4	462	4	water__weed
waterweeds	17	4	366	4	water_weeds
waterwheels	20	5	165	4	waterwheels
waterwork	19	4	665	4	water__work
waterworks	20	4	617	4	waterwo_rks
waterworn	15	4	618	4	water__worn
waterzoois	22	5	352	4	waterzo_ois
waverers	14	31	861	4	waver___ers
willpowers	18	4	289	4	w_illpowers
windrowers	17	4	384	4	windr_owers
winegrowers	18	5	197	4	winegrowers
womanpowers	21	5	141	4	womanpowers

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	148819	0.403	443402.0
2	DLD Change Limit	148819	76	8.296	17938.6
3	Display Results	76	76	0.033	2303.0
	(SQL Overall)	178691	76	8.732	20463.9