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

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

289 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
flight	13	40	1481	(None)
alight	10	38	1686	1	alight
blight	12	41	1462	1	blight
fight	12	40	2709	1	f_ight
flights	14	33	1098	1	flights
flighty	17	34	743	1	flighty
fright	13	37	1524	1	fright
light	9	44	2960	1	_light
plight	12	35	1336	1	plight
slight	10	34	1600	1	slight
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
fanlight	15	4	584	2	fanlight
fights	13	38	1655	2	f_ights
fliest	9	47	1842	2	fliest
flighted	16	4	697	2	flighted
flint	8	73	3350	2	fli_nt
flirt	8	74	2475	2	fli_rt
flit	7	65	3927	2	fli__t
fought	13	51	1239	2	fought
freight	14	4	760	2	freight
frights	14	33	962	2	frights
height	13	47	1343	2	height
hight	12	53	2723	2	_hight
inflight	15	4	589	2	inflight
knight	14	3	817	2	knight
licht	10	47	2349	2	_licht
lights	10	45	1991	2	_lights
might	11	38	2708	2	_might
night	9	43	2785	2	_night
plights	13	29	931	2	plights
relight	11	5	1206	2	relight
right	9	44	3050	2	_right
sight	9	46	2929	2	_sight
sleight	11	27	902	2	sleight
slights	11	28	1072	2	slights
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
affright	18	4	419	3	affright
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
faggot	11	3	904	3	faggot
fagot	9	3	2340	3	f_agot
faint	8	58	3706	3	fai_nt
faith	11	56	2085	3	faith_
faiths	12	46	1027	3	faiths
fanlights	16	4	392	3	fanlights
faugh	12	57	1296	3	faugh_
feign	9	42	1071	3	feig_n
feigns	10	40	775	3	feigns
feint	8	47	3225	3	fei_nt
feist	8	62	3007	3	fei_st
fiat	7	66	4664	3	f_i_at
fiche	13	46	1674	3	f_iche
fichu	13	48	1066	3	f_ichu
fidget	11	42	1647	3	fidget
fifth	14	52	1092	3	f_ifth
fig	7	62	4283	3	f_ig__
fighter	14	30	1076	3	f_ighter
figs	8	53	3264	3	f_ig_s
filch	13	48	1332	3	filch_
filet	8	55	4016	3	f_ilet
fillet	9	50	2708	3	fillet
filth	11	50	1582	3	filth_
filths	12	38	978	3	filths
filthy	15	35	642	3	filthy
firelight	16	5	553	3	f~~ire~~light
first	8	62	2612	3	f_irst
firth	11	58	1953	3	f_irth
fish	10	69	2627	3	f_ish_
fishy	14	60	1166	3	f_ishy
fist	7	62	4842	3	f_i_st
fit	6	63	6545	3	f_i__t
fixit	15	48	1930	3	f_ixit
fixt	14	107	2971	3	f_i_xt
flag	8	74	2708	3	flag__
flaggy	14	41	592	3	flaggy
flagon	10	3	798	3	flagon
flags	9	53	2128	3	flag_s
flash	11	57	1621	3	flash_
flashy	15	49	817	3	flashy
flat	7	71	4782	3	fl__at
flaunt	9	7	1291	3	flaunt
fleche	14	29	930	3	fleche
fleet	8	59	3233	3	fl_eet
flesh	11	50	1374	3	flesh_
fleshy	15	40	628	3	fleshy
flic	9	62	2373	3	fli__c
flichter	16	6	496	3	flichter
flick	14	50	1721	3	fli_ck
flicks	15	45	1299	3	flicks
flics	10	54	1836	3	fli_cs
flied	9	65	1943	3	fli_ed
flier	8	60	2340	3	fli_er
fliers	9	44	1719	3	fliers
flies	8	56	3071	3	fli_es
flightier	16	4	442	3	flight~~ier~~
flightily	19	4	335	3	flight~~ily~~
flighting	17	3	610	3	flight~~ing~~
flimsy	14	34	556	3	flimsy
flinch	14	40	1010	3	flinch
fling	9	70	2351	3	fli_ng
flinger	11	37	1050	3	flinger
flings	10	67	1528	3	flings
flints	9	56	1745	3	flints
flinty	12	61	1249	3	flinty
flip	9	63	2426	3	fli__p
flippy	16	5	461	3	flippy
flips	10	51	1774	3	fli_ps
flir	7	64	2220	3	fli__r
flirs	8	55	1893	3	fli_rs
flirts	9	54	1148	3	flirts
flirty	12	49	914	3	flirty
flitch	14	92	817	3	flitch
flite	8	54	2496	3	fli_te
flited	10	46	1658	3	flited
flites	9	51	2244	3	flites
flits	8	56	2522	3	fli_ts
float	8	59	2857	3	fl_oat
flog	8	55	2389	3	flog__
flogs	9	59	1996	3	flog_s
floret	9	3	2112	3	floret
flout	8	62	2620	3	fl_out
fluent	9	3	1393	3	fluent
fluish	12	3	933	3	fluish_
flush	11	51	1607	3	flush_
fluyt	11	46	1420	3	fl_uyt
flyweight	22	5	253	3	fl~~ywe~~ight
foist	8	57	3097	3	foi_st
footlight	16	25	527	3	f~~oot~~light
forgat	10	40	1858	3	forgat
forget	10	63	2639	3	forget
forgot	10	43	1813	3	forgot
fraught	14	26	635	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
gaslight	13	9	534	3	gaslight
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	1991	3	_high_
highs	12	54	1252	3	_highs
highth	12	38	914	3	_highth
hights	13	37	1689	3	_hights
infight	14	3	745	3	infight
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	1924	3	_ligate
liger	6	50	2446	3	_liger
lighted	12	29	1350	3	_lighted
lighten	11	28	1152	3	_lighten
lighter	11	31	1342	3	_lighter
lightly	14	36	902	3	_lightly
lilt	4	63	4994	3	_li_lt
limit	7	31	2633	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	1020	3	_mighty
mislight	14	4	724	3	mislight
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
preflight	18	4	467	3	~~pre~~flight
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
safelight	16	12	447	3	safelight
sigh	8	56	2589	3	_sigh_
sighs	9	54	1674	3	_sighs
sights	10	38	1801	3	_sights
skylight	19	4	399	3	skylight
sleigh	10	25	820	3	sleigh_
sleighs	11	24	567	3	sleighs
sleights	12	27	591	3	sleights
sliest	6	66	2194	3	sliest
slighted	13	5	739	3	slighted
slighter	12	5	782	3	slighter
slightly	15	4	460	3	slightly
slipt	7	66	2748	3	sli_pt
slit	4	62	5010	3	sli__t
sought	10	63	1505	3	sought
spigot	9	3	1260	3	spigot
spright	13	20	1040	3	spright
sunlight	12	4	596	3	sunlight
taught	10	43	1222	3	taught
thigh	12	4	1011	3	thigh_
thighs	13	4	662	3	thighs
tights	10	40	1585	3	_tights
tonight	11	3	874	3	tonight
topflight	18	4	354	3	~~top~~flight
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.140	1276364.3
2	DLD Change Limit	112716	289	6.503	17332.9
3	Display Results	289	289	0.170	1700.0
	(SQL Overall)	178691	289	6.813	26227.9