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

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

47 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
prancers	12	32	1033	(None)
prancer	11	36	1338	1	prancer_
prances	11	36	1877	1	prance_s
bracers	11	46	1670	2	bra_cers
branders	11	43	1309	2	branders
branners	10	40	1092	2	branners
cancers	11	40	1858	2	_cancers
chancers	15	43	1348	2	chancers
dancers	10	34	1309	2	_dancers
frankers	15	34	835	2	frankers
glancers	11	40	800	2	glancers
grangers	10	30	1197	2	grangers
granters	9	36	1413	2	granters
lancers	9	36	1664	2	_lancers
pacers	10	51	2454	2	p_a_cers
panders	10	34	2373	2	p_anders
paniers	9	47	1733	2	p_aniers
panners	9	36	2127	2	p_anners
panzers	18	40	1201	2	p_anzers
pincers	11	39	1650	2	p_incers
placers	11	45	1526	2	pla_cers
planers	9	45	1794	2	plan_ers
planners	10	39	993	2	planners
planters	10	29	1532	2	planters
pouncers	12	34	920	2	pouncers
praisers	10	34	1083	2	praisers
prance	10	43	1857	2	prance__
pranced	12	37	1404	2	prance_d
praters	9	49	2164	2	pra_ters
prawners	13	4	600	2	prawners
prayers	12	42	1285	2	pra_yers
precancers	16	4	525	2	precancers
pricers	11	39	1506	2	pr_icers
princes	11	30	1514	2	prince_s
princess	12	26	680	2	princess
prinkers	14	30	1038	2	prinkers
printers	10	32	1490	2	printers
pruners	9	37	1072	2	prun_ers
racers	8	47	2543	2	_ra_cers
rances	8	46	2544	2	_rance_s
ranchers	13	33	1179	2	_ranchers
rancors	9	8	1137	2	_rancors
rangers	8	36	2104	2	_rangers
rankers	11	32	1746	2	_rankers
ranters	7	33	2364	2	_ranters
tracers	9	49	1783	2	tra_cers
trances	9	39	1964	2	trance_s

Search took 6 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.296	603685.8
2	DLD Change Limit	121059	47	4.813	25152.5
3	Display Results	47	47	0.033	1424.2
	(SQL Overall)	178691	47	5.142	34751.3