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

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

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.

80 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
powders	13	41	1155	(None)
polders	10	36	1737	1	polders
ponders	10	36	1884	1	ponders
powder	12	36	1190	1	powder_
powdery	16	39	612	1	powdery
powers	11	38	2232	1	pow_ers
powters	12	40	1566	1	powters
bonders	10	41	2066	2	bonders
borders	10	43	1753	2	borders
bowers	11	55	2370	2	bow_ers
bowlders	14	30	649	2	bowlders
bowlers	12	37	1578	2	bowlers
bowyers	15	43	873	2	bowyers
chowders	17	38	754	2	chowders
clowders	14	35	747	2	clowders
codders	11	41	1445	2	codders
coders	9	54	2698	2	co_ders
corders	10	45	2088	2	corders
cowers	11	46	2553	2	cow_ers
crowders	14	39	880	2	crowders
dodders	10	55	1179	2	dodders
dowers	10	45	2329	2	dow_ers
downers	11	39	1277	2	downers
dowsers	11	50	1353	2	dowsers
fodders	12	40	1075	2	fodders
folders	11	35	1439	2	folders
fowlers	13	34	1120	2	fowlers
holders	11	37	1590	2	holders
howlers	13	33	1235	2	howlers
loaders	8	34	1343	2	loaders
lowers	9	46	2492	2	low_ers
molders	10	33	1555	2	molders
mowers	11	32	1940	2	mow_ers
nodders	9	44	1026	2	nodders
orders	7	43	1599	2	_orders
owners	9	42	1070	2	_owners
padders	11	33	1287	2	padders
panders	10	34	2373	2	panders
pawers	11	48	1878	2	paw_ers
pawners	12	43	1107	2	pawners
pewters	12	41	1335	2	pewters
pinders	10	37	2047	2	pinders
plodders	12	3	552	2	plodders
plowers	12	38	1224	2	plow_ers
poisers	9	42	1443	2	poisers
pokers	12	46	1792	2	po_kers
polder	9	40	1925	2	polder_
polers	8	42	2564	2	po_lers
pollers	9	34	2002	2	pollers
ponder	9	45	2169	2	ponder_
poolers	9	42	1742	2	poolers
poppers	10	34	1486	2	poppers
porkers	13	43	1493	2	porkers
porters	9	37	2270	2	porters
posers	8	42	2397	2	po_sers
posters	9	39	2801	2	posters
pothers	12	38	1862	2	pothers
potters	9	40	2434	2	potters
potzers	18	40	1054	2	potzers
pounders	11	31	1328	2	pounders
pourers	9	35	1367	2	pourers
pouters	9	42	2187	2	pouters
powdered	15	25	689	2	powdered
powderer	14	24	559	2	powderer
powderers	15	21	479	2	powderers
power	10	53	2595	2	pow_er_
powter	11	41	1603	2	powter_
prodders	12	3	746	2	prodders
prowlers	13	32	893	2	prowlers
rowers	9	49	2457	2	row_ers
scowders	14	27	622	2	scowders
solders	8	35	1777	2	solders
sonders	8	38	2071	2	sonders
sowers	9	49	2344	2	sow_ers
towers	9	44	2367	2	tow_ers
voiders	11	27	982	2	voiders
vowers	12	43	1718	2	vow_ers
wonders	11	33	1599	2	wonders
wowsers	13	48	876	2	wowsers
yowlers	13	32	892	2	yowlers

Search took 4 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	107671	0.376	475242.0
2	DLD Change Limit	107671	80	3.016	35699.9
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.422	52218.3