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

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

331 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
bright	12	42	1592	(None)
aright	10	38	1766	1	aright
bight	11	87	2884	1	b_ight
blight	12	41	1462	1	blight
brights	13	37	1023	1	brights
fright	13	37	1524	1	fright
right	9	44	3050	1	_right
wright	13	37	1351	1	wright
alight	10	38	1686	2	alight
alright	11	4	885	2	alright
bedight	14	3	748	2	bedight
bights	12	44	1796	2	b_ights
bigot	8	48	2832	2	b_igot
blights	13	31	1021	2	blights
blighty	16	35	684	2	blighty
bought	12	51	1564	2	bought
brig	7	65	2803	2	brig__
brighten	14	6	624	2	brighten
brighter	14	7	666	2	brighter
brightly	17	6	455	2	brightly
brigs	8	58	2322	2	brig_s
brit	6	63	5015	2	bri__t
brith	10	49	2437	2	brith_
briths	11	51	1386	2	briths
britt	7	57	3223	2	bri_tt
brought	13	30	869	2	brought
brugh	11	54	1429	2	brugh_
brughs	12	50	906	2	brughs
dight	10	40	2700	2	_dight
eight	9	49	2805	2	_eight
fight	12	40	2709	2	_fight
flight	13	40	1481	2	flight
freight	14	4	760	2	freight
frights	14	33	962	2	frights
height	13	47	1343	2	height
hight	12	53	2723	2	_hight
knight	14	3	817	2	knight
light	9	44	2960	2	_light
might	11	38	2708	2	_might
night	9	43	2785	2	_night
plight	12	35	1336	2	plight
righto	10	41	1109	2	_righto
rights	10	40	1933	2	_rights
righty	13	50	1183	2	_righty
sight	9	46	2929	2	_sight
slight	10	34	1600	2	slight
spright	13	20	1040	2	spright
tight	9	36	2650	2	_tight
unbright	14	4	470	2	unbright
upright	13	17	829	2	upright
weight	13	39	1418	2	weight
wight	12	37	2557	2	_wight
wrights	14	31	899	2	wrights
abought	13	4	615	3	abought
affright	18	4	419	3	affright
airtight	12	4	597	3	airtight
alights	11	32	1143	3	alights
argot	6	77	2865	3	ar_got
aught	9	51	2070	3	_aught
baht	9	67	4001	3	b__aht
bait	6	65	5600	3	bai__t
baith	10	80	2313	3	baith_
bedights	15	4	474	3	bedights
begat	8	66	2972	3	b_egat
beget	8	56	3256	3	b_eget
begirt	9	4	1268	3	begirt
begot	8	46	2595	3	b_egot
beige	8	15	1538	3	beig_e
beiges	9	10	1441	3	beiges
beigne	9	14	861	3	beigne
beignet	10	15	1096	3	beignet
beigy	11	11	1058	3	beig_y
beknight	18	4	356	3	beknight
bidet	8	49	3563	3	b_idet
big	6	73	4573	3	b_ig__
biggy	12	44	1313	3	b_iggy
bighted	14	28	1092	3	b_ighted
bigly	11	48	1475	3	b_igly
bigos	8	50	2001	3	b_igos
bigots	9	50	1513	3	b_igots
bigs	7	62	3503	3	b_ig_s
binit	7	64	3158	3	b_init
bint	6	73	5505	3	b_i_nt
biont	7	7	2716	3	b_iont
birch	12	49	1402	3	birch_
birth	10	56	1987	3	birth_
births	11	57	1360	3	births
bit	5	70	7091	3	b_i__t
bitt	6	55	4582	3	b_i_tt
blighted	15	4	686	3	blighted
blighter	14	6	685	3	blighter
blithe	11	58	1086	3	blithe
borscht	14	4	599	3	borscht
borsht	11	8	1350	3	borsht
bough	11	57	1931	3	bough_
boughs	12	54	1437	3	boughs
brach	12	61	2330	3	brach_
brachet	14	40	2031	3	brachet
brachs	13	44	1575	3	brachs
bract	9	63	3272	3	br_act
brag	7	52	2972	3	brag__
braggy	13	33	717	3	braggy
brags	8	56	2510	3	brag_s
brant	7	47	4217	3	br_ant
brash	10	62	2156	3	brash_
brashy	14	52	1059	3	brashy
brat	6	60	5554	3	br__at
breast	8	3	1963	3	breast
breath	11	39	1626	3	breath
bregma	11	3	496	3	bregma
brent	7	57	3413	3	br_ent
brevet	11	57	1733	3	brevet
briar	7	57	1815	3	bri_ar
briard	9	43	1129	3	briard
briars	8	48	1482	3	briars
briary	11	49	1200	3	briary
bribe	9	48	2078	3	bri_be
bribed	11	53	1284	3	bribed
bribee	10	43	1636	3	bribee
briber	10	47	1405	3	briber
bribes	10	59	1853	3	bribes
brick	13	46	1815	3	bri_ck
bricks	14	46	1462	3	bricks
bricky	17	48	909	3	bricky
bridal	9	5	1145	3	bridal
bride	8	64	2554	3	bri_de
brides	9	44	2351	3	brides
bridge	10	37	1188	3	bridge
bridged	12	33	903	3	bridged
bridges	11	39	1133	3	bridges
bridle	9	41	1546	3	bridle
brie	6	58	3790	3	bri__e
brief	10	54	2260	3	bri_ef
briefs	11	55	1007	3	briefs
brier	7	45	2740	3	bri_er
briers	8	53	1973	3	briers
briery	11	45	1077	3	briery
bries	7	49	4215	3	bri_es
brigade	11	3	649	3	brigade
brigand	11	3	664	3	brigand
brightens	15	6	537	3	bright~~ens~~
brightest	15	4	566	3	brigh~~tes~~t
brightish	18	6	366	3	bright~~ish~~
brill	7	48	1995	3	bri_ll
brillo	8	42	1100	3	brillo
brills	8	49	1629	3	brills
brim	8	56	2937	3	bri__m
brims	9	47	2162	3	bri_ms
brin	6	70	3819	3	bri__n
brine	7	51	3227	3	bri_ne
brined	9	51	1841	3	brined
briner	8	45	1904	3	briner
brines	8	50	2885	3	brines
bring	8	55	2850	3	bri_ng
bringer	10	42	1335	3	bringer
brings	9	46	1843	3	brings
brink	11	61	2200	3	bri_nk
brinks	12	46	1631	3	brinks
brins	7	55	3397	3	bri_ns
briny	10	47	1966	3	bri_ny
brio	6	54	3249	3	bri__o
brioche	14	27	592	3	brioche
briony	11	4	904	3	briony
brios	7	47	2572	3	bri_os
briquet	18	3	883	3	briquet
bris	6	55	3961	3	bri__s
brisant	9	3	1268	3	brisant
brises	8	49	2761	3	brises
brisk	11	56	1598	3	bri_sk
brisket	13	44	1340	3	brisket
brisks	12	46	1140	3	brisks
briss	7	58	2427	3	bri_ss
brits	7	64	3308	3	bri_ts
britts	8	48	1344	3	britts
broche	13	36	1210	3	broche
brogan	9	3	1104	3	brogan
brogue	9	42	1103	3	brogue
broth	10	65	2109	3	broth_
broths	11	50	1392	3	broths
brothy	14	51	962	3	brothy
bruit	7	61	2672	3	br_uit
brulot	8	9	1221	3	brulot
brunet	8	44	1929	3	brunet
brunt	7	57	2875	3	br_unt
brush	10	59	1747	3	brush_
brushy	14	46	826	3	brushy
brut	6	65	3796	3	br__ut
budget	10	46	1812	3	budget
built	7	43	2592	3	bui_lt
burgh	11	52	1603	3	burgh_
burghs	12	51	992	3	burghs
caught	12	49	1168	3	caught
crit	6	57	4371	3	cri__t
delight	12	6	1067	3	delight
dights	11	40	1696	3	_dights
digit	7	38	2527	3	_digit
dought	11	49	1552	3	dought
draught	12	26	698	3	draught
dreigh	11	24	644	3	dreigh_
driegh	11	25	456	3	driegh_
driest	7	47	2275	3	driest
drift	9	57	2284	3	dri_ft
dript	8	69	2387	3	dri_pt
drought	12	25	888	3	drought
eighth	13	33	1060	3	_eighth
eights	10	36	1898	3	_eights
eighty	13	37	1160	3	_eighty
ergot	6	54	2289	3	er_got
eyebright	18	5	203	3	~~eye~~bright
fights	13	38	1655	3	_fights
flights	14	33	1098	3	flights
flighty	17	34	743	3	flighty
fought	13	51	1240	3	fought
fraught	14	26	636	3	fraught
freights	15	5	585	3	freights
frig	8	54	2450	3	frig__
frigate	11	3	1106	3	frigate
friges	10	41	1648	3	friges
frighted	16	5	717	3	frighted
frighten	15	6	644	3	frighten
frigid	11	3	692	3	frigid
frigs	9	60	1927	3	frig_s
frit	7	70	4447	3	fri__t
frith	11	59	2203	3	frith_
friths	12	43	1358	3	friths
fritt	8	61	2941	3	fri_tt
gighe	10	13	973	3	_gighe
gigot	7	40	2307	3	_gigot
grift	9	59	2446	3	gri_ft
grig	6	54	2477	3	grig__
grigri	8	3	385	3	grigri
grigs	7	53	1819	3	grig_s
griot	6	53	2841	3	gri_ot
gript	8	51	2617	3	gri_pt
grist	6	55	2987	3	gri_st
grit	5	52	4724	3	gri__t
grith	9	55	2037	3	grith_
griths	10	52	1165	3	griths
grivet	10	35	1782	3	grivet
heigh	12	48	1254	3	heigh_
heighth	13	36	634	3	heighth
heights	14	39	944	3	heights
high	11	66	1993	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
insight	11	3	791	3	insight
knights	15	4	565	3	knights
laigh	9	55	1592	3	laigh_
laighs	10	50	880	3	laighs
licht	10	47	2349	3	_licht
lights	10	45	1991	3	_lights
mights	12	35	1625	3	_mights
mighty	15	43	1021	3	_mighty
naught	10	43	1249	3	naught
neigh	9	49	1238	3	neigh_
neighs	10	38	773	3	neighs
nigh	8	52	2067	3	_nigh_
nighs	9	50	1361	3	_nighs
nights	10	41	1772	3	_nights
nighty	13	56	1127	3	_nighty
nought	10	47	1397	3	nought
orient	6	3	2253	3	orient
origan	7	3	1069	3	origan
origin	7	3	1103	3	origin
orisha	9	3	677	3	orisha
ought	9	52	2154	3	_ought
outright	12	4	874	3	outright
plights	13	29	931	3	plights
prefight	17	4	639	3	prefight
priest	8	41	2542	3	priest
prig	7	59	2487	3	prig__
prigs	8	52	1970	3	prig_s
print	7	48	3746	3	pri_nt
privet	11	38	2134	3	privet
refight	14	8	887	3	refight
relight	11	5	1206	3	relight
resight	11	5	1064	3	resight
riant	5	58	3315	3	_riant
rich	9	70	2555	3	_rich_
rift	7	56	4234	3	_ri_ft
rig	4	67	4813	3	_rig__
righted	12	29	1214	3	_righted
righter	11	32	1238	3	_righter
rightly	14	38	904	3	_rightly
rigid	7	9	1389	3	_rigid
rigor	6	27	1405	3	_rigor
rigs	5	51	3760	3	_rig_s
riot	4	59	4722	3	_ri_ot
rishi	8	3	1125	3	_rishi
rivet	8	56	3636	3	_rivet
sigh	8	56	2590	3	_sigh_
sighs	9	54	1674	3	_sighs
sights	10	38	1801	3	_sights
sleight	11	27	902	3	sleight
slights	11	28	1072	3	slights
sought	10	63	1506	3	sought
spigot	9	3	1260	3	spigot
sprights	14	16	714	3	sprights
straight	12	4	918	3	straight
taught	10	43	1224	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
tricot	8	3	1775	3	tricot
trig	5	55	2816	3	trig__
trigly	10	38	1094	3	trigly
trigo	6	57	1605	3	trig_o
trigon	7	45	1310	3	trigon
trigos	7	42	1417	3	trigos
trigs	6	54	2306	3	trig_s
trijet	13	39	1655	3	trijet
trivet	9	37	2188	3	trivet
unsight	11	3	748	3	unsight
uplight	13	16	736	3	uplight
uprights	14	14	531	3	uprights
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
wriest	9	44	1971	3	wriest
wrist	8	48	2756	3	wri_st
writ	7	55	3791	3	wri__t
writhe	12	53	1070	3	writhe
wrought	14	27	693	3	wrought

Search took 6 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.390	458182.1
2	DLD Change Limit	112716	331	5.313	21215.1
3	Display Results	331	331	0.110	3009.1
	(SQL Overall)	178691	331	5.813	30739.9