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

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

271 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
wright	13	37	1351	(None)
aright	10	38	1766	1	aright
bright	12	42	1592	1	bright
fright	13	37	1524	1	fright
right	9	44	3050	1	_right
weight	13	39	1418	1	weight
wight	12	37	2557	1	w_ight
wrights	14	31	899	1	wrights
alight	10	38	1686	2	alight
alright	11	4	885	2	alright
bight	11	87	2884	2	_bight
blight	12	41	1462	2	blight
brights	13	37	1023	2	brights
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
upright	13	17	829	2	upright
waught	13	38	1104	2	waught
weigh	12	54	1251	2	weigh_
weighs	13	33	887	2	weighs
weights	14	40	955	2	weights
weighty	17	37	623	2	weighty
whisht	15	45	1081	2	whisht
wights	13	33	1578	2	w_ights
wriest	9	44	1971	2	wriest
wrist	8	48	2756	2	wri_st
writ	7	55	3791	2	wri__t
writhe	12	53	1070	2	writhe
wrought	14	27	693	2	wrought
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
aweigh	13	3	493	3	aweigh_
bedight	14	3	748	3	bedight
bights	12	44	1796	3	_bights
bigot	8	48	2832	3	_bigot
blights	13	31	1021	3	blights
blighty	16	35	684	3	blighty
bought	12	51	1564	3	bought
brig	7	65	2803	3	brig__
brighten	14	6	624	3	brighten
brighter	14	7	666	3	brighter
brightly	17	6	455	3	brightly
brigs	8	58	2322	3	brig_s
brit	6	63	5015	3	bri__t
brith	10	49	2437	3	brith_
briths	11	51	1386	3	briths
britt	7	57	3223	3	bri_tt
brought	13	30	869	3	brought
brugh	11	54	1429	3	brugh_
brughs	12	50	906	3	brughs
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
downright	17	4	330	3	downright
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
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
lowlight	15	5	494	3	lowlight
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
twilight	15	4	390	3	twilight
twinight	15	4	307	3	twinight
unbright	14	4	470	3	unbright
unsight	11	3	748	3	unsight
unweight	15	4	474	3	unweight
uplight	13	16	736	3	uplight
uprights	14	14	531	3	uprights
uptight	13	17	603	3	uptight
waist	8	61	3238	3	wai_st
wait	7	55	5369	3	wai__t
wariest	10	51	2250	3	wariest
waucht	14	39	941	3	waucht
waugh	12	54	1168	3	waugh_
waughts	14	35	596	3	waughts
wecht	13	4	1544	3	w_echt
weighed	15	13	593	3	weighed
weigher	14	13	634	3	weigher
weighted	16	3	559	3	weighted
weighter	15	3	560	3	weighter
which	16	39	1008	3	which_
whig	11	55	1642	3	whig__
whigs	12	56	1264	3	whig_s
whilst	12	3	914	3	whilst
whipt	13	53	1742	3	whi_pt
whish	14	45	1292	3	whish_
whishts	16	42	531	3	whishts
whist	11	53	2295	3	whi_st
whit	10	48	3417	3	whi__t
wich	12	57	2475	3	w_ich_
widget	11	38	1526	3	widget
width	12	3	1097	3	w_idth
wig	7	67	4039	3	w_ig__
wigan	9	51	1439	3	w_igan
wiggy	13	45	1073	3	w_iggy
wiglet	10	55	1915	3	w_iglet
wigs	8	49	3126	3	w_ig_s
wilt	7	62	4630	3	w_i_lt
wiriest	10	38	1685	3	wiriest
wish	10	72	2874	3	w_ish_
wisha	11	49	1085	3	w_isha
wist	7	80	4930	3	w_i_st
wit	6	65	6378	3	w_i__t
with	10	57	3048	3	w_ith_
withe	11	52	2023	3	w_ithe
withy	14	48	1376	3	w_ithy
wraith	12	5	860	3	wraith_
wraiths	13	5	503	3	wraiths
wrapt	10	51	2318	3	wr_apt
wrath	11	57	1587	3	wrath_
wraths	12	38	1008	3	wraths
wrathy	15	37	785	3	wrathy
wreath	12	41	1119	3	wreath
wrest	8	49	2543	3	wr_est
wrick	14	40	1339	3	wri_ck
wricks	15	46	1062	3	wricks
wried	9	55	1856	3	wri_ed
wrier	8	45	2175	3	wri_er
wries	8	58	2774	3	wri_es
wriggle	12	31	621	3	wriggle
wriggly	15	32	489	3	wriggly
wring	9	59	2071	3	wri_ng
wringed	12	37	1019	3	wringed
wringer	11	36	1245	3	wringer
wrings	10	40	1297	3	wrings
wrists	9	54	1564	3	wrists
wristy	12	50	970	3	wristy
write	8	55	2283	3	wri_te
writer	9	44	1651	3	writer
writes	9	44	2033	3	writes
writhed	14	38	962	3	writhed
writhen	13	40	786	3	writhen
writher	13	40	1085	3	writher
writhes	13	48	1170	3	writhes
writs	8	66	2438	3	wri_ts
wroth	11	68	1588	3	wroth_
wryest	12	42	911	3	wryest

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.373	479064.3
2	DLD Change Limit	112716	271	4.660	24188.0
3	Display Results	271	271	0.093	2914.0
	(SQL Overall)	178691	271	5.126	34859.7