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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

144 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
sightly	14	40	827	(None)
lightly	14	36	902	1	lightly
nightly	14	44	903	1	nightly
rightly	14	38	904	1	rightly
slightly	15	4	460	1	slightly
tightly	14	32	761	1	tightly
brightly	17	6	455	2	brightly
eighthly	18	4	370	2	eighthly
eighty	13	37	1160	2	eight_y
highly	16	3	682	2	high_ly
knightly	19	5	301	2	knightly
lichtly	15	25	552	2	lichtly
mightily	17	4	462	2	mightily
mighty	15	43	1021	2	might_y
nighty	13	56	1127	2	night_y
righty	13	50	1183	2	right_y
sight	9	46	2929	2	sight__
sighted	12	31	1152	2	sighted
sighter	11	34	1211	2	sighter
sights	10	38	1801	2	sight_s
sixthly	20	4	287	2	sixthly
sprightly	18	13	366	2	sprightly
unsightly	16	4	308	2	unsightly
bight	11	87	2884	3	bight__
bighted	14	28	1092	3	bighted
bights	12	44	1796	3	bight_s
bigly	11	48	1475	3	big__ly
bigotry	13	4	452	3	bigotry
blighty	16	35	684	3	blight_y
dight	10	40	2700	3	dight__
dighted	13	25	1149	3	dighted
dights	11	40	1696	3	dight_s
eight	9	49	2805	3	eight__
eighth	13	33	1060	3	eight_h
eighths	14	38	829	3	eighths
eights	10	36	1898	3	eight_s
eightvo	14	4	384	3	eightvo
fifthly	19	4	309	3	fifthly
fight	12	40	2709	3	fight__
fighter	14	30	1077	3	fighter
fights	13	38	1655	3	fight_s
firstly	13	3	564	3	firstly
fishily	16	3	764	3	fishily
fitly	11	51	1497	3	fi__tly
flightily	19	4	335	3	flightily
flighty	17	34	743	3	flight_y
giggly	12	51	870	3	gig_gly
highboy	19	4	339	3	highboy
hight	12	53	2723	3	hight__
highted	15	27	1016	3	highted
highth	12	38	915	3	hight_h
highths	13	35	800	3	highths
hightop	16	4	501	3	hightop
hights	13	37	1689	3	hight_s
highway	20	4	426	3	highway
jiggly	18	37	871	3	jig_gly
licitly	12	27	667	3	licitly
light	9	44	2960	3	light__
lighted	12	29	1350	3	lighted
lighten	11	28	1152	3	lighten
lighter	11	31	1344	3	lighter
lights	10	45	1991	3	light_s
lithely	13	5	664	3	lithely
might	11	38	2708	3	might__
mights	12	35	1625	3	might_s
niggly	11	41	891	3	nig_gly
night	9	43	2785	3	night__
nightie	11	7	965	3	nightie
nights	10	41	1772	3	night_s
ninthly	13	4	421	3	ninthly
pigsty	12	3	593	3	pigst_y
pithily	15	6	703	3	pithily
riantly	10	3	761	3	riantly
richly	14	3	800	3	rich_ly
right	9	44	3050	3	right__
righted	12	29	1214	3	righted
righter	11	32	1238	3	righter
righto	10	41	1109	3	right_o
rights	10	40	1933	3	right_s
rigidly	12	3	553	3	rigidly
sagely	10	28	1138	3	sag_ely
saintly	10	3	934	3	saintly
scantly	12	41	955	3	scantly
shaly	11	43	2286	3	s__haly
shily	11	52	2201	3	s__hily
shortly	13	38	757	3	shortly
shyly	14	48	1157	3	s__hyly
sickly	15	31	1048	3	si_ckly
sigh	8	56	2589	3	sigh___
sighed	11	37	1205	3	sigh_ed
sigher	10	38	1370	3	sigh_er
sighers	11	37	1218	3	sighers
sighing	12	33	1166	3	sighing
sighs	9	54	1674	3	sigh__s
sighters	12	25	1060	3	sighters
sighting	13	31	1086	3	sighting
sightless	13	8	592	3	sightless
sightlier	13	4	445	3	sightlier
sightline	13	4	568	3	sightline
sightsaw	15	4	269	3	sightsaw
sightsee	12	4	547	3	sightsee
sigil	6	35	1550	3	sig_il_
sigils	7	39	1236	3	sig_ils
sigla	6	45	1520	3	sig__la
signal	7	37	1148	3	signal_
signally	12	4	653	3	signally
signals	8	35	916	3	signals
signify	14	4	485	3	signify
signory	11	42	752	3	signory
silently	11	4	748	3	silently
silkily	14	23	696	3	silkily
sillily	10	20	978	3	sillily
silly	8	45	2762	3	si__lly
silty	8	47	2163	3	si_lt_y
simply	13	30	1052	3	si_mply
singly	10	40	1585	3	si_ngly
sixty	15	49	1273	3	si_xt_y
sizably	21	3	661	3	sizably
slantly	10	39	932	3	slantly
slight	10	34	1600	3	slight__
slighted	13	5	739	3	slighted
slighter	12	5	782	3	slighter
slights	11	28	1072	3	slight_s
smartly	12	49	743	3	smartly
softly	12	45	776	3	s_oftly
soggily	12	3	595	3	soggily
soothly	13	18	692	3	soothly
squatly	19	4	643	3	squatly
stoutly	10	3	583	3	stoutly
straightly	17	5	311	3	s~~tra~~ightly
subtly	11	24	926	3	s_ubtly
sweetly	13	3	559	3	sweetly
swiftly	16	3	373	3	swiftly
swithly	16	3	444	3	swith_ly
tight	9	36	2650	3	tight__
tighten	11	28	897	3	tighten
tighter	11	29	1069	3	tighter
tights	10	40	1585	3	tight_s
uprightly	18	14	240	3	uprightly
weightily	19	4	246	3	weightily
weighty	17	37	623	3	weight_y
wiggly	14	55	968	3	wig_gly
wight	12	37	2557	3	wight__
wights	13	33	1578	3	wight_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.390	458182.1
2	DLD Change Limit	134027	144	6.530	20524.8
3	Display Results	144	144	0.050	2880.0
	(SQL Overall)	178691	144	6.970	25637.2