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

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

346 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
slight	10	34	1600	(None)
alight	10	38	1686	1	alight
blight	12	41	1462	1	blight
flight	13	40	1481	1	flight
light	9	44	2960	1	_light
plight	12	35	1336	1	plight
sight	9	46	2929	1	s_ight
sleight	11	27	902	1	sleight
slights	11	28	1072	1	slights
alights	11	32	1143	2	alights
alright	11	4	885	2	alright
aright	10	38	1766	2	aright
bight	11	87	2884	2	_bight
blights	13	31	1021	2	blights
blighty	16	35	684	2	blighty
bright	12	42	1592	2	bright
delight	12	6	1067	2	delight
dight	10	40	2700	2	_dight
eight	9	49	2805	2	_eight
fight	12	40	2709	2	_fight
flights	14	33	1098	2	flights
flighty	17	34	743	2	flighty
fright	13	37	1524	2	fright
gaslight	13	9	534	2	gaslight
height	13	47	1343	2	height
hight	12	53	2723	2	_hight
knight	14	3	817	2	knight
licht	10	47	2349	2	_licht
lights	10	45	1991	2	_lights
might	11	38	2708	2	_might
mislight	14	4	724	2	mislight
night	9	43	2785	2	_night
plights	13	29	931	2	plights
relight	11	5	1206	2	relight
right	9	44	3050	2	_right
sigh	8	56	2589	2	s_igh_
sighs	9	54	1674	2	s_ighs
sights	10	38	1801	2	s_ights
skylight	19	4	399	2	skylight
sleigh	10	25	820	2	sleigh_
sleighs	11	24	567	2	sleighs
sleights	12	27	591	2	sleights
sliest	6	66	2196	2	sliest
slighted	13	5	739	2	slighted
slighter	12	5	782	2	slighter
slightly	15	4	460	2	slightly
slipt	7	66	2748	2	sli_pt
slit	4	62	5010	2	sli__t
sought	10	63	1505	2	sought
spigot	9	3	1260	2	spigot
spright	13	20	1040	2	spright
sunlight	12	4	596	2	sunlight
tight	9	36	2650	2	_tight
uplight	13	16	736	2	uplight
weight	13	39	1418	2	weight
wight	12	37	2557	2	_wight
wright	13	37	1351	2	wright
alighted	13	4	767	3	alighted
align	6	50	1650	3	alig_n
aligns	7	53	1295	3	aligns
alist	5	61	3678	3	ali_st
alit	4	61	5569	3	ali__t
aliyot	9	36	1171	3	aliyot
almighty	17	4	268	3	almighty
aught	9	51	2070	3	_aught
bedight	14	3	748	3	bedight
bights	12	44	1796	3	_bights
bigot	8	48	2832	3	_bigot
blighted	15	4	686	3	blighted
blighter	14	6	685	3	blighter
blithe	11	58	1086	3	blithe
bought	12	51	1563	3	bought
brights	13	37	1023	3	brights
caught	12	49	1168	3	caught
claught	13	3	510	3	claught
cliche	13	37	1245	3	cliche
client	8	3	1634	3	client
clift	10	64	2219	3	cli_ft
clipt	9	63	2427	3	cli_pt
daylight	16	4	451	3	daylight
delights	13	4	733	3	delights
dights	11	40	1696	3	_dights
digit	7	38	2527	3	_digit
dought	11	49	1551	3	dought
eighth	13	33	1060	3	_eighth
eights	10	36	1898	3	_eights
eighty	13	37	1160	3	_eighty
elegit	7	12	1289	3	elegit
elicit	8	4	1720	3	elicit
elint	5	54	3647	3	eli_nt
fanlight	15	4	584	3	fanlight
fights	13	38	1655	3	_fights
fliest	9	47	1843	3	fliest
flighted	16	4	697	3	flighted
flint	8	73	3350	3	fli_nt
flirt	8	74	2475	3	fli_rt
flit	7	65	3927	3	fli__t
fought	13	51	1239	3	fought
freight	14	4	760	3	freight
frights	14	33	962	3	frights
gaslights	14	6	375	3	gaslights
gastight	13	6	521	3	gastight
gighe	10	13	973	3	_gighe
gigot	7	40	2307	3	_gigot
glint	6	68	3018	3	gli_nt
heigh	12	48	1254	3	heigh_
heighth	13	36	634	3	heighth
heights	14	39	944	3	heights
high	11	66	1992	3	_high_
highs	12	54	1252	3	_highs
highth	12	38	915	3	_highth
hights	13	37	1689	3	_hights
infight	14	3	745	3	infight
inflight	15	4	589	3	inflight
insight	11	3	791	3	insight
klepht	15	3	504	3	klepht
knights	15	4	565	3	knights
laigh	9	55	1592	3	laigh_
laighs	10	50	880	3	laighs
legit	6	13	2350	3	_legit
lich	9	62	3084	3	_lich_
lichi	10	44	1295	3	_lichi
lichts	11	37	1238	3	_lichts
licit	7	43	2768	3	_licit
lift	7	69	4272	3	_li_ft
ligan	6	79	2028	3	_ligan
ligate	7	25	1925	3	_ligate
liger	6	50	2447	3	_liger
lighted	12	29	1350	3	_lighted
lighten	11	28	1152	3	_lighten
lighter	11	31	1344	3	_lighter
lightly	14	36	902	3	_lightly
lilt	4	63	4994	3	_li_lt
limit	7	31	2634	3	_limit
lint	4	162	6623	3	_li_nt
lirot	5	4	3003	3	_lirot
list	4	70	5534	3	_li_st
lit	3	93	7731	3	_li__t
lithe	8	49	2201	3	_lithe
litho	8	65	1378	3	_litho
lowlight	15	5	494	3	lowlight
mights	12	35	1625	3	_mights
mighty	15	43	1021	3	_mighty
mislights	15	4	466	3	mislights
naught	10	43	1249	3	naught
neigh	9	49	1238	3	neigh_
neighs	10	38	773	3	neighs
nigh	8	52	2066	3	_nigh_
nighs	9	50	1361	3	_nighs
nights	10	41	1772	3	_nights
nighty	13	56	1127	3	_nighty
nought	10	47	1396	3	nought
oiltight	12	4	454	3	oiltight
ought	9	52	2153	3	_ought
penlight	14	4	642	3	penlight
pliant	8	39	1882	3	pliant
plighted	15	4	646	3	plighted
plighter	14	7	662	3	plighter
plinth	11	3	1045	3	plinth
refight	14	8	887	3	refight
relights	12	4	805	3	relights
resight	11	5	1064	3	resight
righto	10	41	1109	3	_righto
rights	10	40	1933	3	_rights
righty	13	50	1183	3	_righty
rushlight	16	4	271	3	rushlight
safelight	16	12	447	3	s~~afe~~light
saiga	6	47	1793	3	saig_a
saigas	7	41	1429	3	saigas
saint	5	51	4707	3	sai_nt
saith	8	58	2655	3	saith_
saithe	9	47	1391	3	saithe
salient	7	4	1976	3	salient
sangh	9	55	1745	3	sangh_
sanghs	10	53	1206	3	sanghs
saugh	9	53	1840	3	saugh_
saughs	10	48	1205	3	saughs
saughy	13	50	746	3	saughy
seiche	11	8	1183	3	seiche
sennight	12	4	514	3	sennight
shiest	9	58	2153	3	shiest
shift	11	42	2514	3	shi_ft
shirt	8	45	3390	3	shi_rt
shist	8	48	2961	3	shi_st
shit	7	67	4594	3	shi__t
sidelight	14	17	548	3	s~~ide~~light
sidh	8	62	2299	3	s_idh_
sidhe	9	53	1510	3	s_idhe
sift	7	107	4066	3	s_i_ft
sighed	11	37	1205	3	s_ighed
sigher	10	38	1370	3	s_igher
sighted	12	31	1152	3	s_ighted
sighter	11	34	1211	3	s_ighter
sightly	14	40	827	3	s_ightly
sigil	6	35	1550	3	s_igil
sigla	6	45	1520	3	s_igla
sigma	8	45	1383	3	s_igma
sign	5	55	2305	3	s_ig_n
signa	6	61	1470	3	s_igna
signet	7	36	2115	3	s_ignet
signs	6	55	1632	3	s_igns
silent	6	41	2584	3	silent
silt	4	65	5819	3	s_i_lt
sinh	7	62	3804	3	s_inh_
sinhs	8	67	1960	3	s_inhs
sit	3	58	7775	3	s_i__t
sith	7	54	3515	3	s_ith_
sixth	15	55	1223	3	s_ixth
skeigh	14	26	590	3	skeigh_
skint	9	56	2922	3	ski_nt
skirt	9	56	2466	3	ski_rt
skit	8	54	3753	3	ski__t
skylights	20	4	284	3	skylights
slag	5	59	3435	3	slag__
slaggy	11	43	879	3	slaggy
slags	6	65	2590	3	slag_s
slant	5	52	3870	3	sl_ant
slash	8	47	1968	3	slash_
slat	4	69	5902	3	sl__at
sleet	5	56	3913	3	sl_eet
sleighed	13	3	403	3	sleighed
sleigher	12	3	431	3	sleigher
slept	7	57	2810	3	sl_ept
sleuth	9	3	723	3	sleuth
slice	7	49	2582	3	sli_ce
sliced	9	44	1631	3	sliced
slicer	8	41	1760	3	slicer
slices	8	40	2285	3	slices
slick	11	55	2052	3	sli_ck
slicks	12	48	1611	3	slicks
slid	5	58	2898	3	sli__d
slide	6	47	2541	3	sli_de
slider	7	39	1836	3	slider
slides	7	39	2218	3	slides
slier	5	48	2724	3	sli_er
slieve	9	35	927	3	slieve
slighters	13	4	671	3	slight~~ers~~
slightest	13	13	695	3	sligh~~tes~~t
slighting	14	3	637	3	slight~~ing~~
slily	8	58	2003	3	sli_ly
slim	6	66	3196	3	sli__m
slime	7	49	2575	3	sli_me
slimed	9	49	1512	3	slimed
slimes	8	47	2204	3	slimes
slimly	11	40	890	3	slimly
slims	7	54	2365	3	sli_ms
slimsy	11	40	772	3	slimsy
slimy	10	54	1742	3	sli_my
sling	6	60	2880	3	sli_ng
slinger	8	34	1383	3	slinger
slings	7	46	1801	3	slings
slingshot	13	5	270	3	slingshot
slink	9	54	2291	3	sli_nk
slinks	10	43	1515	3	slinks
slinky	13	39	910	3	slinky
slip	6	70	3173	3	sli__p
slipe	7	56	2613	3	sli_pe
sliped	9	54	1706	3	sliped
slipes	8	49	2141	3	slipes
slipout	9	4	908	3	slipout
slippy	13	7	584	3	slippy
slips	7	60	2372	3	sli_ps
slipup	10	3	450	3	slipup
slither	10	41	1298	3	slither
slits	5	61	2885	3	sli_ts
slitty	9	32	916	3	slitty
sliver	9	41	1659	3	sliver
slog	5	67	2827	3	slog__
slogan	7	53	922	3	slogan
slogs	6	45	2184	3	slog_s
slosh	8	45	1448	3	slosh_
sloshy	12	36	662	3	sloshy
slot	4	60	4983	3	sl__ot
sloth	8	50	1945	3	sloth_
sloths	9	49	1189	3	sloths
slough	10	53	923	3	slough_
sloughs	11	49	756	3	sloughs
sloughy	14	53	580	3	sloughy
slug	5	51	2464	3	slug__
slugs	6	46	1856	3	slug_s
slush	8	53	1657	3	slush_
slushy	12	41	722	3	slushy
slut	4	50	4059	3	sl__ut
slyest	9	38	1136	3	slyest
smit	6	51	3841	3	smi__t
smith	10	78	1805	3	smith_
smiths	11	47	1102	3	smiths
smithy	14	50	827	3	smithy
sniglet	8	36	1241	3	sniglet
snit	4	63	4247	3	sni__t
soigne	7	43	1003	3	soigne
solicit	9	3	1574	3	solicit
sorgho	10	34	871	3	sorgho
sough	9	53	2046	3	sough_
soughs	10	51	1562	3	soughs
spigots	10	3	779	3	spigots
spilt	7	55	3222	3	spi_lt
spilth	11	46	973	3	spilth
spinet	8	56	2975	3	spinet
spirit	8	35	1992	3	spirit
spirt	7	50	3295	3	spi_rt
spit	6	55	4508	3	spi__t
splint	8	52	2328	3	spli_nt
split	7	57	2901	3	spli__t
spotlight	15	4	371	3	s~~pot~~light
sprights	14	16	714	3	sprights
starlight	13	4	591	3	s~~tar~~light
stich	10	41	1792	3	stich_
stichs	11	45	1165	3	stichs
stigma	9	22	676	3	stigma
stilt	5	48	3198	3	sti_lt
stint	5	70	3766	3	sti_nt
stithy	12	39	821	3	stithy
stoplight	15	8	428	3	s~~top~~light
straight	12	4	918	3	straight
sugh	8	64	2344	3	s_ugh_
sughs	9	53	1332	3	s_ughs
suint	5	56	3818	3	sui_nt
suit	4	56	4987	3	sui__t
sunlights	13	4	400	3	sunlights
swift	11	68	1805	3	swi_ft
swig	8	58	1802	3	swig__
swigs	9	62	1366	3	swig_s
swish	11	51	1482	3	swish_
swishy	15	36	584	3	swishy
swith	11	59	1740	3	swith_
swithe	12	40	1068	3	swithe
swivet	12	36	1547	3	swivet
taught	10	43	1222	3	taught
thigh	12	4	1012	3	thigh_
thighs	13	4	663	3	thighs
tights	10	40	1585	3	_tights
tonight	11	3	874	3	tonight
twilight	15	4	390	3	twilight
unsight	11	3	748	3	unsight
uplights	14	16	505	3	uplights
upright	13	17	829	3	upright
uptight	13	17	603	3	uptight
waught	13	38	1104	3	waught
weigh	12	54	1251	3	weigh_
weighs	13	33	887	3	weighs
weights	14	40	955	3	weights
weighty	17	37	623	3	weighty
whisht	15	45	1081	3	whisht
wights	13	33	1578	3	_wights
wrights	14	31	899	3	wrights

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	112716	0.373	479064.3
2	DLD Change Limit	112716	346	5.923	19030.2
3	Display Results	346	346	0.123	2813.0
	(SQL Overall)	178691	346	6.419	27837.8