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

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

71 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
pruning	10	3	1173	(None)
aproning	11	3	1179	2	aproning
brining	10	32	1647	2	brining
bruting	10	26	1299	2	bruting
bruxing	17	23	682	2	bruxing
burning	10	42	1550	2	burning
craning	10	36	2030	2	craning
droning	9	30	1372	2	droning
durning	9	35	1173	2	durning
grunting	10	26	958	2	grunting
ironing	8	24	1401	2	ironing
paining	10	39	2024	2	paining
panning	10	40	1939	2	panning
pausing	10	39	1281	2	pausing
pawning	13	47	1141	2	pawning
peening	10	33	1830	2	peening
peining	10	46	1915	2	peining
penning	10	36	1649	2	penning
perusing	11	8	1106	2	perusing
phoning	13	3	1205	2	phoning
pining	9	37	2653	2	p_ining
pinning	10	34	1785	2	pinning
planing	10	34	1825	2	planing
pluming	12	34	1204	2	pluming
plunging	12	35	767	2	plunging
plunking	15	32	848	2	plunking
pouncing	13	31	888	2	pouncing
pounding	12	33	1147	2	pounding
pouring	10	31	1586	2	pouring
pouting	10	35	1994	2	pouting
prancing	13	26	1216	2	prancing
pranging	12	30	1272	2	pranging
pranking	15	38	1338	2	pranking
prating	10	34	2445	2	prating
prawning	14	4	696	2	prawning
praying	13	37	1732	2	praying
preeing	10	38	1767	2	preeing
preening	11	31	1584	2	preening
preying	13	31	1455	2	preying
pricing	12	34	1734	2	pricing
priding	11	33	1754	2	priding
priming	12	34	1737	2	priming
prinking	15	32	1245	2	prinking
printing	11	32	1608	2	printing
prising	10	33	2145	2	prising
prizing	19	35	1468	2	prizing
probing	12	33	1444	2	probing
pronging	12	35	1184	2	pronging
prosing	10	33	1938	2	prosing
proving	13	42	1407	2	proving
prying	12	41	1480	2	pr_ying
puking	13	39	1306	2	p_uking
puling	9	36	2140	2	p_uling
punning	10	34	1499	2	punning
punting	10	33	1844	2	p_unting
purging	11	33	1418	2	purging
purling	10	36	2029	2	purling
purring	10	45	1582	2	purring
pursing	10	37	1555	2	pursing
ruing	6	72	2105	2	_ru_ing
ruining	8	35	1488	2	_ruining
ruling	7	32	1955	2	_ruling
running	8	35	1459	2	_running
sprucing	13	3	689	2	sprucing
spurning	11	25	866	2	spurning
trining	8	29	1921	2	trining
trucing	10	32	1184	2	trucing
trueing	8	34	1018	2	trueing
truing	7	39	1393	2	tru_ing
tuning	7	40	1684	2	_tuning
turning	8	37	1318	2	turning

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	71	3.000	35890.3
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	3.406	52463.6