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

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

53 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
height	13	47	1343	(None)
eight	9	49	2805	1	_eight
heigh	12	48	1254	1	heigh_
heighth	13	36	634	1	heighth
heights	14	39	944	1	heights
hight	12	53	2723	1	h_ight
weight	13	39	1418	1	weight
alight	10	38	1686	2	alight
aright	10	38	1766	2	aright
bedight	14	3	748	2	bedight
bight	11	87	2884	2	_bight
blight	12	41	1462	2	blight
bright	12	42	1592	2	bright
delight	12	6	1067	2	delight
dight	10	40	2700	2	_dight
eighth	13	33	1060	2	_eighth
eights	10	36	1898	2	_eights
eighty	13	37	1160	2	_eighty
fight	12	40	2709	2	_fight
flight	13	40	1481	2	flight
freight	14	4	760	2	freight
fright	13	37	1524	2	fright
heighten	15	4	570	2	heighten
heighths	14	32	482	2	heighths
heishi	12	3	584	2	heishi
heist	8	70	3091	2	hei_st
heugh	12	54	1092	2	heugh_
heughs	13	51	690	2	heughs
high	11	66	1992	2	h_igh_
highs	12	54	1252	2	h_ighs
highth	12	38	915	2	h_ighth
hights	13	37	1689	2	h_ights
knight	14	3	817	2	knight
light	9	44	2960	2	_light
might	11	38	2708	2	_might
neigh	9	49	1238	2	neigh_
neighs	10	38	773	2	neighs
night	9	43	2785	2	_night
plight	12	35	1336	2	plight
refight	14	8	887	2	refight
relight	11	5	1206	2	relight
resight	11	5	1064	2	resight
right	9	44	3050	2	_right
sight	9	46	2929	2	_sight
sleight	11	27	902	2	sleight
slight	10	34	1600	2	slight
tight	9	36	2650	2	_tight
weigh	12	54	1251	2	weigh_
weighs	13	33	887	2	weighs
weights	14	40	955	2	weights
weighty	17	37	623	2	weighty
wight	12	37	2557	2	_wight
wright	13	37	1351	2	wright

Search took 3 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	82551	0.373	479064.3
2	DLD Change Limit	82551	53	2.283	36159.0
3	Display Results	53	53	0.013	4076.9
	(SQL Overall)	178691	53	2.669	66950.5