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

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

237 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
alights	11	32	1143	(None)
alight	10	38	1686	1	alight_
blights	13	31	1021	1	blights
flights	14	33	1098	1	flights
lights	10	45	1991	1	_lights
plights	13	29	931	1	plights
slights	11	28	1072	1	slights
alighted	13	4	767	2	alighted
aligns	7	53	1295	2	alig_ns
almighty	17	4	268	2	almighty
alright	11	4	885	2	alright_
aright	10	38	1766	2	aright_
aughts	10	47	1024	2	a_ughts
bights	12	44	1796	2	_bights
blight	12	41	1462	2	blight_
blighty	16	35	684	2	blighty
brights	13	37	1023	2	brights
daylights	17	4	328	2	daylights
delights	13	4	733	2	delights
dights	11	40	1696	2	_dights
eights	10	36	1898	2	_eights
fanlights	16	4	392	2	fanlights
fights	13	38	1655	2	_fights
flight	13	40	1481	2	flight_
flighty	17	34	743	2	flighty
frights	14	33	962	2	frights
gaslights	14	6	375	2	gaslights
heights	14	39	944	2	heights
hights	13	37	1689	2	_hights
knights	15	4	565	2	knights
laighs	10	50	880	2	laigh_s
lichts	11	37	1238	2	_lichts
light	9	44	2960	2	_light_
mights	12	35	1625	2	_mights
nights	10	41	1772	2	_nights
plight	12	35	1336	2	plight_
relights	12	4	805	2	relights
rights	10	40	1933	2	_rights
sights	10	38	1801	2	_sights
sleights	12	27	591	2	sleights
slight	10	34	1600	2	slight_
tights	10	40	1585	2	_tights
uplights	14	16	505	2	uplights
weights	14	40	955	2	weights
wights	13	33	1578	2	_wights
wrights	14	31	899	2	wrights
adits	6	65	2371	3	adi__ts
affrights	19	4	289	3	affrights
aghas	9	70	1487	3	a__ghas
agists	7	57	1317	3	agi_sts
aiglets	8	40	1291	3	a_iglets
aigrets	8	28	1053	3	a_igrets
airths	9	54	1425	3	a_irths
airts	5	56	2634	3	a_i_rts
aits	4	63	5553	3	a_i__ts
alants	6	77	2202	3	al_ants
alegars	8	3	893	3	alegars
alephs	11	3	653	3	aleph_s
alerts	6	44	1822	3	al_erts
algas	6	56	2493	3	al_g_as
algins	7	48	1643	3	al_gins
algors	7	3	1255	3	al_gors
algums	9	20	804	3	al_gums
alias	5	58	3460	3	ali__as
aliases	7	9	1449	3	aliases
alibies	9	3	1332	3	alibies
alibis	8	3	1107	3	ali_bis
alidads	9	3	629	3	alidads
aliens	6	56	1921	3	ali_ens
alifs	8	61	2126	3	ali__fs
alighting	14	4	641	3	alighting
align	6	50	1650	3	alig__n
aligned	9	12	855	3	aligned
aligner	8	10	830	3	aligner
aligners	9	11	756	3	aligners
aliments	10	3	1109	3	aliments
aliners	7	47	1772	3	aliners
alines	6	57	3522	3	ali_nes
alipeds	10	38	679	3	alipeds
aliquots	17	4	364	3	aliquots
alist	5	61	3678	3	ali_st_
alit	4	61	5569	3	ali__t_
aliyahs	13	39	532	3	aliyahs
aliyas	9	39	1180	3	ali_yas
aliyos	9	34	953	3	ali_yos
aliyot	9	36	1171	3	aliyot_
allots	6	40	1917	3	al_lots
almahs	11	86	1161	3	almah_s
almehs	11	61	949	3	almeh_s
alohas	9	4	1170	3	al_ohas
alphas	11	3	951	3	al_phas
alts	4	66	3990	3	al___ts
amigas	9	59	1216	3	amig_as
amigos	9	45	1120	3	amig_os
angsts	7	3	886	3	a_ngsts
argots	7	41	1602	3	a_rgots
aught	9	51	2070	3	a_ught_
backlights	22	5	399	3	backlights
bedights	15	4	474	3	bedights
bight	11	87	2884	3	_bight_
bigots	9	50	1513	3	_bigots
blighted	15	4	686	3	blighted
blighter	14	6	685	3	blighter
blighters	15	5	573	3	blighters
blighties	15	4	622	3	blighties
bright	12	42	1592	3	bright_
caliches	15	38	1226	3	caliches
caliphs	14	3	675	3	caliph_s
catfights	18	4	279	3	catfights
claughts	14	4	338	3	claughts
cliches	14	42	1374	3	cliches
clients	9	3	809	3	clients
clifts	11	51	915	3	cli_fts
daylight	16	4	451	3	daylight_
deadlights	16	4	299	3	deadlights
delight	12	6	1067	3	delight_
dight	10	40	2700	3	_dight_
digits	8	41	1453	3	_digits
eight	9	49	2805	3	_eight_
eighth	13	33	1060	3	_eighth
eighths	14	38	829	3	_eighths
eighty	13	37	1160	3	_eighty
elegits	8	14	934	3	elegits
elicits	9	3	1123	3	elicits
elints	6	58	1642	3	eli_nts
fanlight	15	4	584	3	fanlight_
fight	12	40	2709	3	_fight_
flighted	16	4	697	3	flighted
flints	9	56	1745	3	fli_nts
flirts	9	54	1148	3	fli_rts
flits	8	56	2522	3	fli__ts
freights	15	5	585	3	freights
fright	13	37	1524	3	fright_
galiots	8	23	1132	3	gali_ots
galipots	11	4	521	3	galipots
gaslight	13	9	534	3	gaslight_
gigots	8	39	1195	3	_gigots
glints	7	57	1421	3	gli_nts
halibuts	13	6	444	3	halibuts
headlights	18	4	293	3	headlights
height	13	47	1343	3	height_
heighth	13	36	634	3	heighth
heighths	14	32	482	3	heighths
highs	12	54	1252	3	_high_s
hight	12	53	2723	3	_hight_
highth	12	38	914	3	_highth
highths	13	35	800	3	_highths
infights	15	4	557	3	infights
insights	12	4	549	3	insights
jacklights	27	5	279	3	jacklights
kaliphs	16	3	429	3	kaliph_s
klephts	16	4	218	3	klephts
knight	14	3	817	3	knight_
laichs	11	51	1089	3	laich_s
laigh	9	55	1592	3	laigh__
lamplights	18	5	266	3	lamplights
laughs	10	48	902	3	laugh_s
legits	7	13	1300	3	_legits
liches	11	47	2429	3	_liches
lichis	11	52	1259	3	_lichis
licht	10	47	2349	3	_licht_
lifts	8	57	1906	3	_li_fts
ligans	7	68	1773	3	_ligans
ligate	7	25	1924	3	_ligate
ligates	8	23	1837	3	_ligates
ligers	7	50	2202	3	_ligers
lighted	12	29	1350	3	_lighted
lighten	11	28	1152	3	_lighten
lightens	12	25	999	3	_lightens
lighter	11	31	1342	3	_lighter
lighters	12	31	1137	3	_lighters
lightest	12	14	1035	3	_lightest
lightish	15	5	662	3	_lightish
lightly	14	36	902	3	_lightly
lilts	5	58	2280	3	_li_lts
limits	8	25	1413	3	_limits
lints	5	71	3719	3	_li_nts
lists	5	66	2869	3	_li_sts
lithos	9	42	1255	3	_lithos
lits	4	62	5249	3	_li__ts
lowlights	16	4	365	3	lowlights
maligns	10	3	813	3	malig_ns
might	11	38	2708	3	_might_
mighty	15	43	1020	3	_mighty
mislights	15	4	466	3	mislights
naughts	11	44	751	3	naughts
neighs	10	38	773	3	neigh_s
nighs	9	50	1361	3	_nigh_s
night	9	43	2785	3	_night_
nighty	13	56	1127	3	_nighty
noughts	11	47	808	3	noughts
oughts	10	47	1018	3	_oughts
penlights	15	4	420	3	penlights
plighted	15	4	646	3	plighted
plighter	14	7	662	3	plighter
plighters	15	4	552	3	plighters
plinths	12	3	612	3	plinths
refights	15	5	588	3	refights
relight	11	5	1206	3	relight_
resights	12	4	673	3	resights
right	9	44	3050	3	_right_
righto	10	41	1109	3	_righto
righty	13	50	1183	3	_righty
safelights	17	14	301	3	safelights
salients	8	3	956	3	salients
sighs	9	54	1674	3	_sigh_s
sight	9	46	2929	3	_sight_
skylights	20	4	284	3	skylights
sleighs	11	24	567	3	sleigh_s
sleight	11	27	902	3	sleight_
slighted	13	5	739	3	slighted
slighter	12	5	782	3	slighter
slighters	13	4	670	3	slighters
slightest	13	13	694	3	slightest
slightly	15	4	460	3	slightly
slits	5	61	2885	3	sli__ts
spigots	10	3	779	3	spigots
sprights	14	16	714	3	sprights
starlights	14	4	398	3	starlights
sunlights	13	4	400	3	sunlights
taillights	14	4	334	3	taillights
talipots	10	4	561	3	talipots
thighs	13	4	662	3	thigh_s
tight	9	36	2650	3	_tight_
tonights	12	4	459	3	tonights
twilights	16	4	253	3	twilights
unsights	12	4	462	3	unsights
uplight	13	16	736	3	uplight_
uprights	14	14	531	3	uprights
valiants	11	3	779	3	valiants
waughts	14	35	596	3	waughts
weighs	13	33	887	3	weigh_s
weight	13	39	1418	3	weight_
weighty	17	37	623	3	weighty
whishts	16	42	531	3	whishts
wight	12	37	2557	3	_wight_
wright	13	37	1351	3	wright_

Search took 9 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.220	812231.8
2	DLD Change Limit	134027	237	7.936	16888.5
3	Display Results	237	237	0.093	2548.4
	(SQL Overall)	178691	237	8.249	21662.1