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

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

50 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
planets	9	39	1408	(None)
placets	11	39	1122	1	placets
planers	9	45	1794	1	planers
planes	8	50	2808	1	plane_s
planet	8	42	2835	1	planet_
plants	8	49	2180	1	plan_ts
alants	6	77	2202	2	alan_ts
alkanets	12	36	623	2	alkanets
blankets	14	35	650	2	blankets
clarets	9	41	1110	2	clarets
flanes	9	45	2242	2	flane_s
lancets	9	34	1116	2	_lancets
lanes	5	49	4679	2	_lane_s
lunets	6	69	1476	2	_lunets
palets	8	51	2231	2	p_alets
pallets	9	39	1930	2	pallets
panels	8	47	1652	2	p_anels
panes	7	61	4869	2	p_ane_s
pants	7	65	3692	2	p_an_ts
peanuts	9	3	699	2	peanuts
placers	11	45	1526	2	placers
places	10	43	2370	2	place_s
placet	10	39	2367	2	placet_
plackets	16	4	658	2	plackets
plages	9	45	2015	2	plage_s
plainest	10	3	1361	2	plainest
plaints	9	40	1205	2	plaints
plaits	8	38	1647	2	pla_its
planate	9	3	1457	2	planate
planchets	16	23	674	2	planchets
plane	7	49	2914	2	plane__
planed	9	44	2091	2	plane_d
planer	8	41	2265	2	plane_r
planks	12	41	1675	2	plan_ks
planless	10	3	681	2	planless
planners	10	39	993	2	planners
plans	7	57	3127	2	plan__s
plant	7	54	3711	2	plan_t_
planted	10	35	1612	2	planted
planter	9	40	1780	2	planter
planters	10	29	1532	2	planters
plantlets	11	4	501	2	plantlets
platens	9	42	1398	2	platens
platers	9	39	2409	2	platers
plates	8	54	3224	2	plate_s
plats	7	55	3137	2	pla__ts
players	12	43	1376	2	players
playlets	13	3	490	2	playlets
punnets	9	40	926	2	punnets
slants	6	48	1908	2	slan_ts

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	50	3.266	32967.2
3	Display Results	50	50	0.030	1666.7
	(SQL Overall)	178691	50	3.669	48702.9