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

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

93 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
poncing	12	29	1358	(None)
ponding	11	43	1708	1	ponding
ponging	11	34	1615	1	ponging
ponying	13	33	1212	1	ponying
pouncing	13	31	888	1	pouncing
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
bouncing	13	31	877	2	bouncing
coning	9	43	3183	2	con_ing
conking	14	36	1845	2	conking
conning	10	37	1876	2	conning
dancing	11	36	1156	2	dancing
donning	9	35	1276	2	donning
fencing	13	24	1113	2	fencing
fonding	12	38	1542	2	fonding
forcing	13	40	1375	2	forcing
gonging	10	37	1303	2	gonging
honing	10	34	2150	2	hon_ing
honking	15	34	1479	2	honking
jouncing	18	33	685	2	jouncing
konking	11	35	1021	2	konking
lancing	10	33	1412	2	lancing
longing	9	39	1578	2	longing
mincing	12	33	1433	2	mincing
noncling	11	3	1076	2	noncling
pacing	11	45	2275	2	p_acing
panging	11	33	1911	2	panging
panning	10	40	1939	2	panning
panting	10	40	2542	2	panting
peacing	12	41	1707	2	peacing
pending	11	41	1977	2	pending
penning	10	36	1649	2	penning
phoning	13	3	1205	2	phon_ing
phonying	17	4	583	2	phonying
piecing	12	4	1045	2	piecing
pinching	16	37	1105	2	pinching
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
placing	12	38	1528	2	placing
plonking	15	35	856	2	plonking
poaching	16	35	1083	2	poaching
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
policing	13	3	1167	2	policing
poling	9	35	2650	2	po_ling
polling	10	29	2038	2	polling
pontine	9	24	1905	2	pontine
pooching	16	32	898	2	pooching
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
porcine	11	3	1284	2	porcine
porcini	11	3	763	2	porcini
porcino	11	3	811	2	porcino
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
pouching	16	32	1041	2	pouching
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
prancing	13	26	1216	2	prancing
pricing	12	34	1734	2	pricing
pronging	12	35	1184	2	pronging
punching	16	33	1012	2	punching
punning	10	34	1499	2	punning
punting	10	33	1844	2	punting
sconcing	13	3	826	2	sconcing
sponging	12	3	882	2	sponging
syncing	13	17	722	2	syncing
tonging	9	33	1451	2	tonging
toning	7	40	2579	2	ton_ing
voicing	13	27	908	2	voicing
wincing	13	34	1390	2	wincing
wonning	11	32	1079	2	wonning
wonting	11	32	1410	2	wonting
zincing	19	29	1028	2	zincing
zoning	16	29	1433	2	zon_ing
zonking	21	35	911	2	zonking

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	93	3.376	31893.1
3	Display Results	93	93	0.030	3100.0
	(SQL Overall)	178691	93	3.779	47285.3