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

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

341 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
flagon	10	3	798	(None)
flacon	11	3	863	1	flacon
flagons	11	3	797	1	flagons
agon	5	65	3188	2	__agon
blazon	17	3	676	2	blazon
claxon	15	3	658	2	claxon
dragon	8	3	884	2	dragon
fagin	9	2	1657	2	f_agin
fagot	9	3	2340	2	f_agot
falcon	11	3	1029	2	falcon
fanon	8	46	1901	2	f_anon
flacons	12	3	805	2	flacons
flag	8	74	2708	2	flag__
flaggy	14	41	592	2	flaggy
flagman	13	18	617	2	flagman
flagmen	13	22	691	2	flagmen
flags	9	53	2128	2	flag_s
flamen	11	52	1599	2	flamen
flan	7	61	3418	2	fla__n
flavin	12	3	930	2	flavin
flavone	13	3	552	2	flavone
flavor	12	3	666	2	flavor
flaxen	16	51	857	2	flaxen
flexagon	19	4	206	2	flexagon
klaxon	17	3	385	2	klaxon
lagan	6	65	2034	2	_lagan
lagoon	7	4	1048	2	_lagoon
logon	6	159	2231	2	_logon
wagon	9	43	1295	2	_wagon
aeon	4	56	3461	3	__aeon
agin	5	61	3271	3	__agin
ago	4	88	4552	3	__ago_
agog	6	80	1900	3	__agog
agone	6	59	2455	3	__agone
agons	6	64	2378	3	__agons
agony	9	64	1565	3	__agony
alamo	7	4	1814	3	alamo_
alamos	8	4	1500	3	alamos
alan	4	68	4408	3	ala__n
alanin	6	3	1727	3	alanin
alation	7	29	2055	3	alation
algin	6	57	1876	3	al_gin
algor	6	5	1305	3	al_gor
align	6	50	1650	3	alig_n
amazon	17	3	682	3	amazon
anlagen	8	23	863	3	anlagen
anon	4	61	3485	3	__anon
argon	6	55	2059	3	_argon
axon	11	55	2430	3	__axon
azon	13	57	2505	3	__azon
bacon	9	56	2059	3	_bacon
ballon	8	41	1749	3	ballon
baron	7	81	3124	3	_baron
baton	7	58	2242	3	_baton
beacon	10	5	1137	3	beacon
blain	7	54	2179	3	bla_in
blawn	10	68	1370	3	bla_wn
blazons	18	3	616	3	blazons
cajon	14	45	1390	3	_cajon
canon	7	47	2530	3	_canon
capon	9	52	2187	3	_capon
celadon	10	3	691	3	celadon
clag	7	59	2457	3	clag__
clags	8	56	2112	3	clag_s
clamor	10	4	945	3	clamor
clan	6	56	3392	3	cla__n
clangor	10	42	668	3	clangor
clarion	9	3	1166	3	clarion
claro	7	50	1869	3	claro_
claros	8	40	1511	3	claros
classon	9	3	769	3	classon
claxons	16	3	580	3	claxons
clon	6	62	3248	3	cl__on
cogon	8	91	2090	3	_cogon
craton	8	45	1719	3	craton
crayon	11	41	1000	3	crayon
dago	6	57	2508	3	_dago_
dagos	7	64	1944	3	_dagos
dalapon	10	4	489	3	dalapon
dalton	7	3	1127	3	dalton
deacon	9	5	1042	3	deacon
decagon	11	3	586	3	decagon
dragons	9	3	838	3	dragons
dragoon	9	3	528	3	dragoon
elain	5	53	2470	3	ela_in
elan	4	67	3424	3	ela__n
elation	7	36	2045	3	elation
elevon	9	7	795	3	elevon
epigon	9	3	796	3	epigon
etalon	6	4	897	3	etalon
fado	8	72	2646	3	f_ado_
fados	9	56	2073	3	f_ados
fag	7	68	5236	3	f_ag__
faggot	11	3	904	3	faggot
faggy	13	65	1437	3	f_aggy
fagins	10	5	1386	3	f_agins
fagots	10	3	996	3	f_agots
fags	8	69	3912	3	f_ag_s
fain	7	58	4056	3	f_a_in
falcons	12	3	912	3	falcons
fallen	9	38	1337	3	fallen
fallow	12	47	1385	3	fallow
fan	6	71	5885	3	f_a__n
fanion	9	45	1432	3	fanion
fano	7	58	3168	3	f_ano_
fanons	9	61	1521	3	f_anons
fanos	8	59	2650	3	f_anos
faro	7	61	3692	3	f_aro_
faros	8	55	3202	3	f_aros
faun	7	62	2662	3	f_a_un
favor	11	47	1245	3	f_avor
fawn	10	53	2195	3	f_a_wn
feign	9	42	1071	3	feig_n
felon	8	46	1929	3	f_elon
flab	9	66	2835	3	fla__b
flabby	16	3	457	3	flabby
flabs	10	58	1864	3	fla_bs
flack	14	45	1941	3	fla_ck
flacks	15	41	1453	3	flacks
flagged	13	45	963	3	flagged
flagger	12	46	934	3	flagger
flagging	14	32	922	3	flagging
flagpole	14	4	358	3	flagpole
flagrant	12	4	763	3	flagrant
flagstone	13	4	428	3	flagstone
flail	8	53	1618	3	fla_il
flails	9	43	1300	3	flails
flair	8	61	1412	3	fla_ir
flairs	9	57	1191	3	flairs
flak	11	60	2617	3	fla__k
flake	12	51	1997	3	fla_ke
flaked	14	47	1565	3	flaked
flaker	13	49	1617	3	flaker
flakes	13	41	1887	3	flakes
flakey	16	44	1051	3	flakey
flaking	15	41	1449	3	flaking
flaky	15	57	1558	3	fla_ky
flam	9	63	3329	3	fla__m
flambe	13	48	915	3	flambe
flame	10	51	2444	3	fla_me
flamed	12	46	1897	3	flamed
flamens	12	46	1106	3	flamens
flamer	11	49	1912	3	flamer
flames	11	47	2369	3	flames
flaming	13	42	1644	3	flaming
flams	10	51	2501	3	fla_ms
flamy	13	52	1747	3	fla_my
flanes	9	45	2242	3	flanes
flange	10	34	1197	3	flange
flanged	12	38	1084	3	flanged
flanger	11	34	1262	3	flanger
flanges	11	34	1327	3	flanges
flanging	13	27	1058	3	flanging
flank	12	46	1809	3	fla_nk
flanken	14	22	676	3	flanken
flanks	13	39	1340	3	flanks
flans	8	53	2797	3	fla_ns
flap	9	61	2870	3	fla__p
flaperon	13	12	484	3	flaperon
flappy	16	5	448	3	flappy
flaps	10	56	2138	3	fla_ps
flare	8	48	2363	3	fla_re
flared	10	53	1760	3	flared
flares	9	45	2170	3	flares
flaring	11	41	1680	3	flaring
flash	11	57	1621	3	fla_sh
flashgun	15	4	217	3	flashgun
flashy	15	49	817	3	flashy
flask	12	55	1242	3	fla_sk
flasks	13	48	867	3	flasks
flat	7	71	4782	3	fla__t
flatiron	11	4	462	3	flatiron
flatlong	12	27	452	3	flatlong
flatly	12	31	1021	3	flatly
flats	8	64	2974	3	fla_ts
flatten	10	42	965	3	flatten
flattop	12	4	440	3	flattop
flatus	9	43	1078	3	flatus
flaunt	9	7	1291	3	flaunt
flauta	9	3	782	3	flauta
flavine	13	3	845	3	flavine
flavins	13	3	854	3	flavins
flavones	14	3	583	3	flavones
flavonol	14	4	221	3	flavonol
flavors	13	3	729	3	flavors
flavory	16	4	474	3	flavory
flavour	13	3	463	3	flavour
flaw	10	63	2664	3	fla__w
flawed	13	47	1272	3	flawed
flawing	14	38	1256	3	flawing
flaws	11	59	2034	3	fla_ws
flawy	14	59	1338	3	fla_wy
flax	14	73	2563	3	fla__x
flaxes	16	50	1535	3	flaxes
flaxy	18	90	1229	3	fla_xy
flay	10	63	3280	3	fla__y
flayed	13	44	1405	3	flayed
flayer	12	47	1356	3	flayer
flaying	14	39	1446	3	flaying
flays	11	63	2105	3	fla_ys
fleuron	10	5	557	3	fleuron
flexagons	20	4	167	3	flexagons
flexion	17	3	507	3	flexion
flexor	16	3	450	3	flexor
flight	13	40	1481	3	flight
floc	9	59	2212	3	fl__oc
floe	7	61	2977	3	fl__oe
flog	8	55	2389	3	fl__og
flogs	9	59	1996	3	flog_s
flong	9	58	1568	3	fl__ong
flood	9	52	1560	3	fl_ood
floor	8	42	1523	3	fl_oor
flop	9	69	2545	3	fl__op
florin	9	3	1265	3	florin
flow	10	59	2492	3	fl__ow
flown	11	62	1399	3	fl_own
fluor	8	45	1277	3	fl_uor
fluxion	17	3	504	3	fluxion
flyboy	17	11	391	3	flyboy
flyman	14	32	642	3	flyman
flymen	14	38	777	3	flymen
foison	9	4	893	3	foison
folacin	12	3	805	3	folacin
fon	6	63	5227	3	f___on
forgo	9	44	1833	3	forgo_
forgone	11	3	934	3	forgone
forgot	10	43	1813	3	forgot
fourgon	11	3	486	3	fourgon
frag	8	51	2627	3	frag__
frags	9	63	2216	3	frag_s
fungo	9	44	1313	3	fungo_
fusion	9	3	977	3	fusion
futon	8	31	1377	3	f_uton
galago	8	3	890	3	galago_
galagos	9	3	814	3	galagos
gallon	7	37	1581	3	gallon
glamor	9	5	818	3	glamor
glucagon	12	4	182	3	glucagon
gluon	6	3	1122	3	gl_uon
gorgon	8	3	1024	3	gorgon
hagdon	11	8	828	3	_hagdon
halon	8	61	2486	3	_halon
hexagon	18	4	382	3	hexagon
imago	8	11	868	3	imago_
imagos	9	11	754	3	imagos
isogon	7	22	754	3	isogon
jargon	14	4	882	3	jargon
kaon	8	75	2102	3	_ka_on
klaxons	18	3	326	3	klaxons
labor	7	51	1731	3	_labor
laden	6	50	2219	3	_laden
ladron	7	34	1332	3	_ladron
lag	4	78	6212	3	_lag__
lagans	7	57	1778	3	_lagans
lagend	8	3	874	3	_lagend
lager	6	51	3286	3	_lager
lagoons	8	3	925	3	_lagoons
lags	5	65	4622	3	_lag_s
laguna	7	12	722	3	_laguna
lagune	7	15	863	3	_lagune
lain	4	61	4628	3	_la_in
lapin	7	52	2292	3	_lapin
lardon	7	44	1506	3	_lardon
largo	6	53	1978	3	_largo_
largos	7	48	1506	3	_largos
laten	5	43	2834	3	_laten
lauan	5	52	1679	3	_lauan
lawn	7	59	2563	3	_la_wn
layin	8	47	2033	3	_layin
legion	7	57	1298	3	_legion
legong	8	3	696	3	_legong
lemon	7	56	1818	3	_lemon
ligan	6	79	2028	3	_ligan
lion	4	63	3444	3	_l_ion
llano	5	9	1060	3	llano_
llanos	6	10	833	3	llanos
logan	6	81	2328	3	_logan
login	6	60	2500	3	_login
logion	7	60	1372	3	_logion
logo	5	79	3176	3	_logo_
logoi	6	97	1594	3	_logoi
logons	7	98	1817	3	_logons
logos	6	72	2533	3	_logos
loon	4	73	4479	3	_l_oon
macon	9	45	1995	3	_macon
magot	8	3	2639	3	_magot
mason	7	48	2018	3	_mason
nonagon	8	4	731	3	nonagon
octagon	10	4	524	3	octagon
paeon	7	48	1949	3	_paeon
pagan	8	61	2116	3	_pagan
pagod	9	50	1368	3	_pagod
paragon	10	3	1102	3	paragon
plafond	13	4	418	3	plafond
plagal	9	4	857	3	plagal
plage	8	45	2040	3	plag_e
plages	9	45	2015	3	plages
plague	9	36	1085	3	plague
plaguy	12	38	641	3	plaguy
plain	7	48	2330	3	pla_in
plan	6	58	3394	3	pla__n
plasmon	11	25	798	3	plasmon
platan	8	39	1369	3	platan
platen	8	45	1820	3	platen
platoon	9	3	895	3	platoon
pleon	7	42	1638	3	pl_eon
pluton	8	3	885	3	pluton
polaron	9	3	984	3	polaron
polygon	13	4	692	3	polygon
racon	7	54	2214	3	_racon
radon	6	46	2050	3	_radon
rayon	8	38	1570	3	_rayon
reagin	7	49	1553	3	reagin
reason	6	26	1633	3	reason
sago	5	63	3267	3	_sago_
sagos	6	61	2387	3	_sagos
salmon	8	46	1418	3	salmon
salon	5	52	2855	3	_salon
saloon	6	44	1802	3	saloon
season	6	27	1490	3	season
slag	5	59	3435	3	slag__
slaggy	11	43	879	3	slaggy
slags	6	65	2590	3	slag_s
slain	5	49	2357	3	sla_in
slalom	8	8	817	3	slalom
slogan	7	53	922	3	slogan
talion	6	3	1771	3	talion
talon	5	58	2411	3	_talon
tauon	5	48	1658	3	_tauon
taxon	12	44	1466	3	_taxon
telamon	9	3	652	3	telamon
tigon	6	39	1444	3	_tigon
trigon	7	45	1310	3	trigon
trogon	7	36	1175	3	trogon
ulan	4	65	2739	3	ula__n
waggon	11	3	639	3	waggon
wagons	10	39	1121	3	_wagons
weakon	13	35	762	3	weakon
weapon	11	28	811	3	weapon
weason	9	32	1082	3	weason
yapon	10	46	1358	3	_yapon

Search took 8 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.263	679433.5
2	DLD Change Limit	112716	341	6.953	16211.1
3	Display Results	341	341	0.143	2384.6
	(SQL Overall)	178691	341	7.359	24282.0