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

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

86 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
ponying	13	33	1212	(None)
phonying	17	4	583	1	phonying
poncing	12	29	1358	1	poncing
ponding	11	43	1708	1	ponding
ponging	11	34	1615	1	ponging
bodying	14	3	897	2	bodying
bonding	11	33	1843	2	bonding
bonging	11	33	1637	2	bonging
boning	9	42	2329	2	bon_ing
bonking	14	41	1637	2	bonking
coning	9	43	3182	2	con_ing
conking	14	36	1845	2	conking
conning	10	37	1875	2	conning
copying	15	34	1198	2	copying
cosying	13	45	1313	2	cosying
coying	12	40	2148	2	co_ying
cozying	22	30	806	2	cozying
denying	12	37	1129	2	denying
donning	9	35	1276	2	donning
epoxying	21	3	303	2	epoxying
fonding	12	38	1542	2	fonding
gonging	10	37	1303	2	gonging
honeying	15	3	767	2	honeying
honing	10	34	2150	2	hon_ing
honking	15	34	1479	2	honking
joying	17	38	1080	2	jo_ying
konking	11	35	1021	2	konking
longing	9	39	1578	2	longing
pandying	15	21	766	2	pandying
panging	11	33	1911	2	panging
panning	10	40	1939	2	panning
panting	10	40	2542	2	panting
paying	12	37	2216	2	p_aying
pending	11	41	1977	2	pending
penning	10	36	1649	2	penning
phoneying	18	4	428	2	phoneying
phoning	13	3	1205	2	phon_ing
pinging	11	34	1955	2	pinging
pining	9	37	2653	2	pin_ing
pinking	14	39	1894	2	pinking
pinning	10	34	1785	2	pinning
pinyin	11	27	1061	2	pinyin_
pitying	13	29	1024	2	pitying
playing	13	38	1609	2	playing
plonking	15	35	856	2	plonking
ploying	13	28	1157	2	ploying
plying	12	43	1208	2	p_lying
pocking	16	39	1676	2	pocking
podding	12	41	1318	2	podding
poinding	12	25	1000	2	poinding
pointing	11	28	1368	2	pointing
poising	10	36	1710	2	poising
poking	13	38	1930	2	po_king
poling	9	35	2650	2	po_ling
polling	10	29	2038	2	polling
pontine	9	24	1905	2	pontine
poohing	13	31	1232	2	poohing
pooing	9	38	2068	2	po_oing
pooling	10	32	1909	2	pooling
pooping	12	36	1544	2	pooping
popping	11	37	1541	2	popping
poring	9	42	2727	2	po_ring
porking	14	35	1581	2	porking
porting	10	30	2178	2	porting
posing	9	39	2264	2	po_sing
posting	10	56	2224	2	posting
potting	10	37	2089	2	potting
pouncing	13	31	888	2	pouncing
pounding	12	33	1147	2	pounding
pouring	10	31	1586	2	pouring
pouting	10	35	1994	2	pouting
poxing	16	37	1494	2	po_xing
praying	13	37	1732	2	praying
preying	13	31	1455	2	preying
pronging	12	35	1184	2	pronging
prying	12	41	1480	2	p_rying
punning	10	34	1499	2	punning
punting	10	33	1844	2	punting
sponging	12	3	882	2	sponging
tonging	9	33	1451	2	tonging
toning	7	40	2579	2	ton_ing
toying	10	50	1730	2	to_ying
wonning	11	32	1079	2	wonning
wonting	11	32	1410	2	wonting
zoning	16	29	1433	2	zon_ing
zonking	21	35	911	2	zonking

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	107671	0.263	679433.5
2	DLD Change Limit	107671	86	7.220	14912.9
3	Display Results	86	86	0.080	1075.0
	(SQL Overall)	178691	86	7.563	23627.0