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

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

60 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
planners	10	39	993	(None)
lanners	7	36	1833	1	_lanners
panners	9	36	2127	1	p_anners
planers	9	45	1794	1	pla_ners
planner	9	35	1162	1	planner_
planters	10	29	1532	1	planters
banners	9	40	1871	2	_banners
branners	10	40	1092	2	branners
canners	9	38	2266	2	_canners
clangers	11	43	1234	2	clangers
fanners	10	39	1465	2	_fanners
flangers	12	33	1137	2	flangers
flankers	15	34	930	2	flankers
flannels	11	3	484	2	flannels
glancers	11	40	800	2	glancers
glanders	10	38	1150	2	glanders
lancers	9	36	1664	2	_lancers
landers	8	40	2621	2	_landers
lanner	6	49	2060	2	_lanner_
manners	9	34	1783	2	_manners
panders	10	34	2373	2	p_anders
paniers	9	47	1733	2	p_aniers
panner	8	42	2476	2	p_anner_
pannes	8	55	2285	2	p_anne_s
panniers	10	48	885	2	p_anniers
panzers	18	40	1201	2	p_anzers
pawners	12	43	1107	2	p_awners
penners	9	34	1418	2	p_enners
pinners	9	35	1860	2	p_inners
placers	11	45	1526	2	pla_cers
plaguers	11	28	650	2	plaguers
plainer	9	38	1198	2	plainer_
plainness	11	5	518	2	plainness
plaiters	10	35	1263	2	plaiters
planeness	11	3	815	2	planeness
planer	8	41	2265	2	pla_ner_
planes	8	50	2808	2	pla_ne_s
planets	9	39	1408	2	pla_nets
plankters	15	4	458	2	plankters
planless	10	3	681	2	planless
planned	10	38	1015	2	planne_d
planter	9	40	1780	2	planter_
plashers	13	38	1345	2	plashers
plasters	10	35	1813	2	plasters
platers	9	39	2409	2	pla_ters
platters	10	34	1528	2	platters
players	12	43	1376	2	pla_yers
plinkers	14	30	939	2	plinkers
plunders	11	32	983	2	plunders
plungers	11	37	940	2	plungers
plunkers	14	32	833	2	plunkers
prancers	12	32	1033	2	prancers
prawners	13	4	600	2	prawners
punners	9	41	1423	2	p_unners
scanners	10	37	970	2	scanners
slanders	9	40	1401	2	slanders
spanners	10	37	1077	2	spanners
tanners	7	40	1839	2	_tanners
uplanders	12	3	485	2	uplanders
vanners	10	36	1284	2	_vanners

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	121059	0.390	458182.1
2	DLD Change Limit	121059	60	3.266	37066.4
3	Display Results	60	60	0.033	1818.2
	(SQL Overall)	178691	60	3.689	48438.9