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

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

83 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
pounder	10	33	1401	(None)
bounder	10	42	1554	1	bounder
founder	11	43	1258	1	founder
hounder	11	34	1224	1	hounder
plunder	10	38	1051	1	plunder
ponder	9	45	2170	1	po_nder
pouncer	11	35	1124	1	pouncer
pounded	11	41	1280	1	pounded
pounders	11	31	1329	1	pounders
rounder	8	35	1461	1	rounder
sounder	8	33	1539	1	sounder
asunder	8	5	623	2	asunder
blunder	10	38	1316	2	blunder
bonder	9	53	2478	2	bo_nder
boulder	10	34	1134	2	boulder
bouncer	11	38	1133	2	bouncer
bounded	11	36	1376	2	bounded
bounden	10	38	945	2	bounden
bounders	11	43	1412	2	bounders
counter	9	42	2015	2	counter
daunder	9	34	890	2	daunder
expounder	19	4	327	2	expounder
flounder	12	3	511	2	flounder
fonder	10	41	2006	2	fo_nder
founded	12	40	1142	2	founded
founders	12	39	1168	2	founders
funder	10	40	1609	2	_funder
grounder	10	4	761	2	grounder
hounded	12	33	1103	2	hounded
hounders	12	31	1172	2	hounders
impounder	14	4	371	2	impounder
joinder	15	33	759	2	joinder
launder	8	30	915	2	launder
louder	7	44	1460	2	lou_der
lounger	8	46	1021	2	lounger
maunder	10	32	869	2	maunder
moulder	10	38	980	2	moulder
mounded	11	37	1198	2	mounded
mounter	9	37	1317	2	mounter
pander	9	37	2553	2	p_ander
pinder	9	45	2346	2	p_inder
plunders	11	32	984	2	plunders
plunger	10	42	1125	2	plunger
plunker	13	39	1066	2	plunker
poinded	11	35	897	2	poinded
pointer	9	38	1493	2	pointer
polder	9	40	1925	2	po_lder
pomander	13	4	708	2	pomander
ponded	10	52	1877	2	po_nded
ponders	10	36	1885	2	po_nders
pornier	9	34	1313	2	pornier
poulter	9	37	1201	2	poulter
pounce	10	52	1409	2	pounce_
pounced	12	35	1062	2	pounced
pouncers	12	34	921	2	pouncers
pounces	11	41	1389	2	pounces
pound	8	44	1786	2	pound__
poundal	10	3	640	2	poundal
pounds	9	37	1438	2	pound_s
pourer	8	45	1604	2	pou_rer
pouter	8	39	2398	2	pou_ter
poutier	9	32	1532	2	poutier
powder	12	36	1190	2	po_wder
prouder	10	3	1038	2	prou_der
pruner	8	34	1346	2	prun_er
punier	8	45	1923	2	p_unier
punker	12	37	1883	2	p_unker
punner	8	49	1816	2	p_unner
punter	8	43	2003	2	p_unter
rounded	9	30	1350	2	rounded
roundel	8	30	885	2	roundel
rounders	9	26	1370	2	rounders
sonder	7	36	2352	2	so_nder
sounded	9	32	1446	2	sounded
sounders	9	32	1412	2	sounders
sunder	7	40	1983	2	_sunder
thunder	11	3	697	2	thunder
under	6	46	2422	2	__under
wonder	10	36	1781	2	wo_nder
wounded	12	32	976	2	wounded
yonder	10	32	1413	2	yo_nder
younger	11	38	716	2	younger
younker	14	31	645	2	younker

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.373	479064.3
2	DLD Change Limit	107671	83	3.126	34443.7
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	3.529	50635.0