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

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

95 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
haughty	17	33	464	(None)
naughty	14	44	562	1	naughty
paughty	16	29	432	1	paughty
aught	9	51	2070	2	_aught_
aughts	10	47	1024	2	_aughts
caught	12	49	1168	2	caught_
doughty	15	43	602	2	doughty
draughty	16	23	352	2	draughty
haugh	12	51	1405	2	haugh__
haughs	13	40	856	2	haugh_s
haughtily	19	4	199	2	haughtily
naught	10	43	1249	2	naught_
naughts	11	44	751	2	naughts
saughy	13	50	746	2	saugh_y
taught	10	43	1223	2	taught_
waught	13	38	1104	2	waught_
waughts	14	35	596	2	waughts
augite	7	3	1261	3	_augite
augury	10	36	666	3	_augury
aunty	8	59	1981	3	_au_nty
blighty	16	35	684	3	blighty
bought	12	51	1564	3	bought_
claught	13	3	510	3	claught_
claughts	14	4	338	3	claughts
daughter	13	4	450	3	daughter
dought	11	49	1552	3	dought_
doughy	14	49	984	3	dough_y
draught	12	26	698	3	draught_
draughts	13	28	475	3	draughts
droughty	16	30	448	3	droughty
eighty	13	37	1160	3	_eighty
faggoty	15	4	286	3	faggoty
faugh	12	57	1296	3	faugh__
faulty	12	42	936	3	fau_lty
flighty	17	34	743	3	flighty
fought	13	51	1240	3	fought_
fraught	14	26	636	3	fraught_
fraughts	15	21	424	3	fraughts
gadgety	13	35	616	3	gadgety
gargety	12	38	804	3	gargety
harshly	16	3	627	3	harshly
hasty	11	57	1876	3	ha__sty
haughtier	16	4	274	3	haughtier
haulmy	14	45	555	3	hau_lmy
haunt	8	52	2913	3	hau_nt_
haunts	9	56	1439	3	hau_nts
haut	7	59	4973	3	hau__t_
hautboy	15	5	342	3	hautboy
haute	8	95	2161	3	hau__te
height	13	47	1343	3	height_
heighth	13	36	634	3	heighth
heights	14	39	944	3	heights
heugh	12	54	1092	3	heugh__
heughs	13	51	690	3	heugh_s
highly	16	3	682	3	h_ighly
hight	12	53	2723	3	h_ight_
highth	12	38	915	3	h_ighth
hights	13	37	1689	3	h_ights
hugely	13	3	680	3	h_ugely
jaunty	16	38	851	3	jau_nty
laugh	9	44	1437	3	laugh__
laughed	12	3	589	3	laughed
laugher	11	3	660	3	laugher
laughs	10	48	902	3	laugh_s
laughter	12	4	511	3	laughter
maggoty	14	4	401	3	maggoty
mighty	15	43	1021	3	_mighty
naughtily	16	4	228	3	naughtily
nighty	13	56	1127	3	_nighty
nought	10	47	1397	3	nought_
noughts	11	47	808	3	noughts
ought	9	52	2154	3	_ought_
oughts	10	47	1018	3	_oughts
paucity	14	3	582	3	paucity
raucity	12	3	585	3	raucity
righty	13	50	1183	3	_righty
roughly	14	50	729	3	roughly
roughy	13	70	1086	3	rough_y
saugh	9	53	1840	3	saugh__
saughs	10	48	1205	3	saugh_s
shaugh	13	28	743	3	shaugh__
shaughs	14	24	528	3	shaugh_s
sought	10	63	1506	3	sought_
teughly	14	44	343	3	teughly
thought	14	63	914	3	thought_
thoughts	15	51	561	3	thoughts
toughly	14	48	743	3	toughly
toughy	13	59	1108	3	tough_y
vaulty	12	38	844	3	vau_lty
vaunty	12	40	906	3	vau_nty
waucht	14	39	941	3	waucht_
wauchts	15	28	528	3	wauchts
waugh	12	54	1168	3	waugh__
waughted	16	4	348	3	waughted
weighty	17	37	623	3	weighty

Search took 8 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.423	422437.4
2	DLD Change Limit	134027	95	6.953	19276.1
3	Display Results	95	95	0.030	3166.7
	(SQL Overall)	178691	95	7.406	24127.9