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

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

62 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
pranging	12	30	1272	(None)
panging	11	33	1911	1	p_anging
prancing	13	26	1216	1	prancing
pranking	15	38	1338	1	pranking
pronging	12	35	1184	1	pronging
ranging	9	41	2026	1	_ranging
arranging	11	5	630	2	arranging
banging	11	40	1986	2	_banging
bragging	13	35	933	2	bragging
branding	12	25	1368	2	branding
branning	11	29	1109	2	branning
bringing	12	30	1127	2	bringing
changing	15	32	1151	2	changing
clanging	12	40	1212	2	clanging
craning	10	36	2030	2	cran_ing
cranking	15	46	1307	2	cranking
cringing	12	33	1138	2	cringing
danging	10	37	1609	2	_danging
deranging	12	3	806	2	deranging
dragging	12	30	810	2	dragging
flanging	13	27	1058	2	flanging
fragging	14	32	942	2	fragging
franking	16	43	1086	2	franking
fringing	13	30	1090	2	fringing
ganging	10	32	1619	2	_ganging
granting	10	35	1452	2	granting
hanging	12	35	1870	2	_hanging
paging	10	40	2040	2	p_a_ging
panning	10	40	1939	2	p_anning
panting	10	40	2542	2	p_anting
parging	11	33	1860	2	p_arging
pinging	11	34	1955	2	p_inging
planing	10	34	1825	2	plan_ing
planking	15	35	1301	2	planking
planning	11	36	1022	2	planning
planting	11	35	1538	2	planting
plunging	12	35	767	2	plunging
ponging	11	34	1615	2	p_onging
praising	11	32	1456	2	praising
prating	10	34	2445	2	pra_ting
prawning	14	4	696	2	prawning
praying	13	37	1732	2	pra_ying
prigging	13	29	909	2	prigging
prinking	15	32	1245	2	prinking
printing	11	32	1608	2	printing
progging	13	26	1038	2	progging
pruning	10	3	1173	2	prun_ing
ragging	10	35	1668	2	_ragging
raging	8	51	2643	2	_ra_ging
ranking	12	43	2088	2	_ranking
ranting	8	40	2541	2	_ranting
ringing	9	35	2128	2	_ringing
slanging	10	34	1343	2	slanging
springing	13	3	874	2	springing
stanging	10	40	1365	2	stanging
tanging	9	34	1953	2	_tanging
trancing	11	28	1202	2	trancing
twanging	13	28	706	2	twanging
whanging	16	26	714	2	whanging
wrangling	14	5	622	2	wrangling
wringing	13	27	962	2	wringing
wronging	13	32	739	2	wronging

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	62	3.936	30756.9
3	Display Results	62	62	0.016	3875.0
	(SQL Overall)	178691	62	4.342	41154.1