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

Here are the results of your fuzzy-string dictionary search for “treetop” with Change Limit: [1] [2] [3] [4]

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.

77 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
treetop	9	4	552	(None)
treetops	10	4	546	1	treetops
redtop	9	3	797	2	_redtop
creator	9	37	1444	3	creator
creep	9	52	1810	3	cree__p
erector	9	35	1381	3	erector
estop	7	43	1210	3	__estop
foretop	12	11	789	3	foretop
freedom	13	4	586	3	freedom
greet	6	58	3532	3	greet__
greeted	9	31	1138	3	greeted
greeter	8	28	1267	3	greeter
greets	7	51	1742	3	greet_s
hereto	9	3	1369	3	hereto_
kreep	11	46	1041	3	kree__p
netop	7	3	1234	3	__netop
overtop	12	3	772	3	overtop
praetor	9	3	897	3	praetor
preop	9	47	1587	3	pr_e_op
presto	8	42	1620	3	presto_
prestos	9	37	1608	3	prestos
pretor	8	3	1575	3	pr_etor
ragtop	9	3	668	3	_ragtop
rebop	9	3	1328	3	_r_ebop
recto	7	45	2080	3	_recto_
rector	8	40	1975	3	_rector
rectos	8	57	1878	3	_rectos
redtops	10	3	737	3	_redtops
rhetor	9	3	806	3	_rhetor
street	6	41	2577	3	street__
streets	7	33	1261	3	street_s
stretto	7	3	773	3	stretto_
strettos	8	4	711	3	strettos
sweetsop	13	4	189	3	sweetsop
tabletop	12	4	341	3	tabletop
teeter	6	54	2031	3	t_eeter
teeth	8	73	1585	3	t_eet_h
teethe	9	45	1131	3	t_eethe
teredo	7	3	1078	3	teredo_
teredos	8	3	918	3	teredos
terete	6	3	1933	3	teret_e
teston	6	3	1330	3	t_eston
theelol	10	4	427	3	theelol
thereto	10	3	899	3	thereto_
threep	11	59	1011	3	three__p
tiptop	10	3	610	3	t_iptop
tractor	9	3	1134	3	tractor
traitor	7	3	1012	3	traitor
treason	7	4	876	3	treason
treat	5	62	4035	3	treat__
treated	8	36	1870	3	treated
treater	7	42	1983	3	treater
treats	6	48	2169	3	treat_s
treaty	9	44	1435	3	treat_y
trecento	10	6	621	3	trecento_
trecentos	11	5	587	3	trecentos
tree	4	77	4581	3	tree___
treed	6	56	2673	3	tree__d
treeing	8	34	1430	3	treeing
treen	5	56	2275	3	tree__n
treens	6	53	1787	3	tree_ns
trees	5	58	3576	3	tree__s
tremor	8	42	1040	3	tr_emor
trestle	7	26	1136	3	trestle
tret	4	66	5353	3	tr_et__
trets	5	59	2802	3	tr_et_s
trevet	9	48	1891	3	trevet__
trevets	10	49	997	3	trevet_s
triton	6	39	1489	3	tr_iton
trollop	9	4	479	3	trollop
troop	7	64	1753	3	tr__oop
trop	6	68	3330	3	tr___op
trustor	7	23	841	3	trustor
tweet	8	48	2398	3	tweet__
tweeted	11	33	658	3	tweeted
tweeter	10	28	853	3	tweeter
tweets	9	42	1010	3	tweet_s

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	77	6.173	21711.8
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	6.609	27037.5