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

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

418 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
longan	7	56	1236	(None)
logan	6	81	2328	1	lo_gan
longans	8	45	1081	1	longans
lungan	7	47	1021	1	lungan
bogan	8	75	1900	2	bo_gan
conga	8	54	1987	2	conga_
congas	9	44	1703	2	congas
donga	7	67	1842	2	donga_
dongas	8	49	1461	2	dongas
eonian	6	3	1183	2	eonian
hogan	9	78	1770	2	ho_gan
honan	8	53	1977	2	hon_an
lagan	6	65	2034	2	l_agan
ligan	6	79	2028	2	l_igan
lignan	7	55	1032	2	lignan
linga	6	68	2082	2	linga_
lingam	9	51	1235	2	lingam
lingas	7	51	1657	2	lingas
loan	4	74	3645	2	lo__an
lochan	11	3	909	2	lochan
logans	7	63	1906	2	lo_gans
login	6	60	2500	2	lo_gin
logon	6	159	2231	2	lo_gon
long	5	69	3334	2	long__
longe	6	66	2646	2	long_e
longed	8	71	2137	2	longed
longer	7	58	2320	2	longer
longes	7	59	2557	2	longes
longhand	13	4	449	2	longhand
longing	9	39	1578	2	longing
longly	10	27	960	2	longly
longs	6	55	2706	2	long_s
loran	5	59	2509	2	lo_ran
lungans	8	39	905	2	lungans
morgan	9	3	1137	2	morgan
nonfan	9	4	829	2	nonfan
nongay	10	16	915	2	nongay
nonman	8	4	1236	2	nonman
organ	6	9	1539	2	_organ
slogan	7	53	922	2	slo_gan
tonga	6	56	1970	2	tonga_
tongas	7	43	1553	2	tongas
tongman	10	3	757	2	tongman
wangan	10	3	1123	2	wangan
aeonian	7	3	835	3	aeonian
along	6	54	1949	3	along__
anga	5	68	3136	3	_anga_
angas	6	58	2799	3	_angas
banian	8	3	1538	3	banian
banyan	11	3	948	3	banyan
began	8	63	1957	3	_began
blowgun	13	4	265	3	blowgun
bogans	9	57	1481	3	bo_gans
bonbon	10	3	1007	3	bonbon
bondman	12	3	804	3	bondman
bong	7	56	3341	3	bong__
bonged	10	57	1960	3	bonged
bonging	11	33	1637	3	bonging
bongo	8	57	2094	3	bong_o
bongos	9	53	1665	3	bongos
bongs	8	78	2842	3	bong_s
bonsai	8	3	846	3	bonsai
bowman	13	12	985	3	bowman
brogan	9	3	1104	3	brogan
cancan	10	3	1410	3	cancan
clonal	8	3	1091	3	clon_al
cognac	11	5	727	3	cognac
cogon	8	91	2090	3	co_gon
coign	8	50	1391	3	coig_n
confab	13	4	706	3	confab
congaed	11	39	974	3	congaed
congaing	12	3	982	3	congaing
conge	8	52	2759	3	cong_e
congeal	10	40	1168	3	congeal
congee	9	60	2447	3	congee
conger	9	50	2427	3	conger
conges	9	49	2817	3	conges
congii	9	5	736	3	congii
congo	8	56	2313	3	cong_o
congos	9	42	1988	3	congos
congou	9	43	1324	3	congou
conin	7	62	3272	3	con_in
conn	6	62	2913	3	con__n
contain	9	3	1583	3	contain
cooncan	11	4	723	3	cooncan
corban	10	3	1469	3	corban
cotan	7	15	2178	3	co_tan
cougar	9	5	878	3	cougar
cowman	13	9	1037	3	cowman
dognap	10	3	534	3	dognap
dolman	9	53	1240	3	dolman
dona	5	55	2963	3	don_a_
donas	6	59	2647	3	don_as
dong	6	60	3165	3	dong__
dongle	8	36	1249	3	dongle
dongs	7	65	2581	3	dong_s
donjon	14	3	646	3	donjon
donna	6	62	1503	3	donna_
donnas	7	55	1132	3	donnas
eloign	7	45	698	3	eloig_n
elongate	9	4	561	3	elongate
eolian	6	3	1259	3	eolian
fanga	9	61	1963	3	fanga_
fangas	10	50	1720	3	fangas
flong	9	58	1568	3	flong__
flongs	10	50	1049	3	flong_s
foeman	11	3	1123	3	foeman
fondant	11	3	1114	3	fondant
fontal	9	3	1314	3	fontal
forgat	10	40	1858	3	forgat
fungal	10	38	873	3	fungal
gan	4	80	6013	3	___gan
gingal	8	10	1015	3	gingal
glonoin	8	7	567	3	glonoin
goban	8	44	1407	3	go_ban
gonad	7	52	1605	3	gon_ad
gong	6	68	2719	3	gong__
gonged	9	71	1591	3	gonged
gonging	10	37	1303	3	gonging
gongs	7	49	2161	3	gong_s
gonia	6	41	1753	3	gonia_
gonion	7	36	1283	3	gonion
gorgon	8	3	1024	3	gorgon
gossan	7	4	723	3	gossan
gowan	9	54	1574	3	go_wan
gunman	9	29	945	3	gunman
hangar	10	41	1452	3	hangar
hangman	13	3	781	3	hangman
hogans	10	59	1431	3	ho_gans
honans	9	48	1450	3	hon_ans
honda	9	4	1498	3	honda_
hondas	10	3	1335	3	hondas
hong	8	58	3395	3	hong__
hongi	9	67	1587	3	hong_i
hongs	9	51	2620	3	hong_s
ionogen	8	3	712	3	ionogen
ironman	9	3	661	3	ironman
jingal	14	9	859	3	jingal
jordan	14	6	806	3	jordan
kanban	12	3	862	3	kanban
klong	10	53	1040	3	klong__
klongs	11	43	660	3	klong_s
koan	8	54	2503	3	ko__an
kurgan	11	12	678	3	kurgan
lagans	7	57	1778	3	l_agans
lallan	6	34	1418	3	lallan
lanai	5	3	1957	3	lan_ai
landau	7	3	1061	3	landau
landman	10	3	892	3	landman
lang	5	66	3739	3	lang__
langshan	12	4	453	3	langshan
langue	7	10	1218	3	langue
langur	7	10	931	3	langur
lantana	7	3	960	3	lantana
laogai	7	3	598	3	laogai
lauan	5	52	1679	3	l_auan
lawman	11	28	905	3	lawman
layman	11	35	1130	3	layman
lean	4	63	4524	3	l__ean
legal	6	57	1594	3	l_egal
leggin	8	26	859	3	leggin
legman	9	4	965	3	legman
leman	7	56	2260	3	l_eman
length	10	4	610	3	length
lensman	9	3	756	3	lensman
lenten	6	3	1288	3	lenten
ligand	8	50	1129	3	l_igand
ligans	7	68	1773	3	l_igans
lignans	8	39	885	3	lignans
lignin	7	49	1119	3	lignin
liman	7	59	2160	3	l_iman
linac	7	3	1541	3	lin_ac
linage	7	7	1340	3	linage
lindane	8	3	903	3	lindane
linden	7	4	1145	3	linden
lineal	6	56	1603	3	lineal
linear	6	51	1334	3	linear
lineman	9	3	912	3	lineman
linen	5	57	2872	3	lin_en
ling	5	74	4796	3	ling__
lingams	10	45	1019	3	lingams
linger	7	52	2600	3	linger
lingo	6	60	2211	3	ling_o
lings	6	71	3577	3	ling_s
lingua	7	50	991	3	lingua
linguae	8	39	841	3	linguae
lingual	8	37	908	3	lingual
lingy	9	69	2514	3	ling_y
linin	5	80	2552	3	lin_in
linkman	13	3	539	3	linkman
linn	4	60	3459	3	lin__n
linsang	8	3	586	3	linsang
load	5	67	3060	3	lo__ad
loaf	7	67	3490	3	lo__af
loam	6	56	3048	3	lo__am
loans	5	60	2646	3	lo__ans
lobar	7	3	1301	3	lo_bar
loca	6	55	2768	3	lo_ca_
local	7	48	2027	3	lo_cal
lochans	12	4	883	3	lochans
loden	6	66	2114	3	lo_den
lodge	7	65	2009	3	lodg_e
lodged	9	138	1571	3	lodged
lodger	8	65	1769	3	lodger
lodges	8	68	2015	3	lodges
lodging	10	31	1081	3	lodging
log	4	62	5268	3	lo_g__
logania	8	4	783	3	lo_gania
loge	5	68	3719	3	lo_g_e
loges	6	65	3420	3	lo_ges
loggats	9	28	645	3	loggats
logged	9	66	2294	3	logged
logger	8	64	2000	3	logger
loggia	8	45	705	3	loggia
loggias	9	35	678	3	loggias
loggie	8	40	1199	3	loggie
logging	10	33	1681	3	logging
loggy	10	57	1419	3	lo_ggy
logia	6	81	1660	3	lo_gia
logic	8	82	1783	3	lo_gic
logins	7	78	2064	3	lo_gins
logion	7	60	1372	3	logion
logjam	16	3	536	3	logjam
logo	5	79	3176	3	lo_g_o
logoi	6	97	1594	3	lo_goi
logons	7	98	1817	3	lo_gons
logos	6	72	2533	3	lo_gos
logs	5	73	4311	3	lo_g_s
logway	13	3	591	3	logway
logy	8	70	2578	3	lo_g_y
loin	4	68	3872	3	lo__in
lomein	8	4	1020	3	lomein
lone	4	58	4913	3	lon__e
lonely	9	29	1247	3	lonely
loner	5	54	3104	3	lon_er
loners	6	42	2581	3	loners
longboat	11	4	609	3	longboat
longbow	13	4	386	3	longbow
longeing	10	17	759	3	longeing
longeron	9	4	576	3	longeron
longers	8	48	1954	3	longers
longest	8	41	1495	3	longest
longhair	12	4	267	3	longhair
longhands	14	4	361	3	longhands
longhead	13	4	508	3	longhead
longhorn	12	4	542	3	longhorn
longies	8	29	1655	3	longies
longings	10	40	856	3	longings
longish	11	22	909	3	longish
longleaf	12	4	366	3	longleaf
longline	9	3	876	3	longline
longways	15	4	387	3	longways
loofa	8	59	1281	3	loofa_
loofah	12	37	581	3	loofah
loofas	9	42	983	3	loofas
loon	4	73	4479	3	lo__on
loosen	6	66	1596	3	loosen
loquat	15	5	828	3	loquat
loral	5	59	2782	3	lo_ral
lorans	6	51	1760	3	lo_rans
loreal	6	38	1431	3	loreal
lorgnon	8	4	442	3	lorgnon
lorn	4	64	3525	3	lo__rn
lota	4	72	3350	3	lo_ta_
lotah	8	53	1585	3	lo_tah
lotas	5	59	2630	3	lo_tas
lotion	6	57	1652	3	lotion
louden	7	37	1179	3	louden
lough	9	51	1848	3	loug_h
loughs	10	50	1477	3	loughs
louma	7	62	1363	3	louma_
loumas	8	48	1233	3	loumas
lounge	7	52	1121	3	loung_e
lounged	9	46	824	3	lounged
lounger	8	46	1021	3	lounger
lounges	8	48	1135	3	lounges
lounging	10	3	675	3	lounging
loungy	10	47	683	3	loung_y
loupen	8	45	1029	3	loupen
lovage	10	3	735	3	lovage
lovat	8	3	2104	3	lo_vat
lowland	11	3	469	3	lowland
lown	7	69	2929	3	lo__wn
loyal	8	45	1348	3	lo_yal
luna	4	62	2985	3	lun_a_
lunar	5	70	1731	3	lun_ar
lunas	5	50	2501	3	lun_as
lung	5	57	3249	3	lung__
lunge	6	53	2380	3	lung_e
lunged	8	54	1827	3	lunged
lungee	7	51	1981	3	lungee
lunger	7	57	2042	3	lunger
lunges	7	61	2342	3	lunges
lungi	6	55	1605	3	lung_i
lunging	9	37	1421	3	lunging
lungis	7	71	1302	3	lungis
lungs	6	52	2388	3	lung_s
lungyi	10	52	509	3	lungyi
lurdan	7	3	836	3	lurdan
lyncean	12	9	292	3	lyncean
manga	8	50	2621	3	manga_
mangas	9	41	2293	3	mangas
mannan	8	54	1362	3	mannan
minyan	11	3	817	3	minyan
moan	6	58	3202	3	mo__an
monad	8	55	1947	3	mon_ad
monas	7	47	3215	3	mon_as
moneran	9	3	1111	3	moneran
monger	9	44	1833	3	monger
mongo	8	101	2241	3	mong_o
mongoe	9	42	1498	3	mongoe
mongol	9	49	1253	3	mongol
mongos	9	43	1862	3	mongos
mongst	9	35	1260	3	mongst
montane	9	13	1362	3	montane
morgans	10	3	1012	3	morgans
morgen	9	3	1220	3	morgen
naan	4	76	2193	3	__naan
nan	3	78	5488	3	__n_an
noggin	8	28	888	3	noggin
nona	4	69	2906	3	non_a_
nonage	7	3	1368	3	nonage
nonagon	8	4	731	3	nonagon
nonas	5	51	2665	3	non_as
nonbank	13	4	590	3	nonbank
nonfans	10	3	753	3	nonfans
nonfat	9	5	1218	3	nonfat
nongame	10	3	818	3	nongame
nongays	11	17	653	3	nongays
nonmen	8	4	1283	3	nonmen
nonpagan	11	4	441	3	nonpagan
nonpar	8	16	899	3	nonpar
nontax	13	4	841	3	nontax
nonwar	9	15	942	3	nonwar
nougat	7	47	1265	3	nougat
ocean	7	12	1296	3	_ocean
octan	7	13	1348	3	_octan
ogam	7	51	2003	3	_o_gam
onion	5	43	2097	3	_onion
onlay	8	42	1294	3	_onlay
organa	7	8	921	3	_organa
organs	7	9	1291	3	_organs
origan	7	3	1069	3	origan
pagan	8	61	2116	3	_pagan
panga	8	53	2354	3	panga_
pangas	9	99	2111	3	pangas
pangen	9	41	1592	3	pangen
penman	10	3	1232	3	penman
plowman	14	4	493	3	plowman
pong	7	62	3114	3	pong__
ponged	10	56	1935	3	ponged
pongee	9	49	2019	3	pongee
pongid	10	41	1158	3	pongid
ponging	11	34	1615	3	ponging
pongs	8	55	2634	3	pong_s
ponton	8	32	1764	3	ponton
popgun	11	4	573	3	popgun
potman	10	28	1357	3	potman
randan	7	3	1525	3	randan
roan	4	72	3420	3	ro__an
rodman	9	4	971	3	rodman
roman	7	54	2482	3	ro_man
ronion	6	33	1564	3	ronion
rontgen	8	3	517	3	rontgen
ronyon	9	30	913	3	ronyon
rowan	8	54	1873	3	ro_wan
sanga	6	60	2380	3	sanga_
sangar	7	36	1769	3	sangar
sangas	7	52	2266	3	sangas
slogans	8	40	798	3	slo_gans
socman	10	3	981	3	socman
solan	5	53	2815	3	so_lan
soldan	7	35	1185	3	soldan
soman	7	50	2490	3	so_man
sonant	6	6	2195	3	son_ant
sonar	5	65	2342	3	son_ar
song	5	51	3367	3	song__
songs	6	77	2555	3	song_s
soudan	7	32	1035	3	soudan
sovran	9	3	715	3	sovran
spongin	10	3	637	3	spongin
suntan	6	26	1300	3	suntan
syngas	10	36	891	3	syngas
tanga	6	49	2371	3	tanga_
tinman	8	24	1114	3	tinman
toga	5	70	2741	3	to_ga_
togae	6	70	2011	3	to_gae
togas	6	78	2300	3	to_gas
tolan	5	51	2401	3	to_lan
toman	7	57	2405	3	to_man
tonal	5	37	2430	3	ton_al
tong	5	64	3436	3	tong__
tonged	8	65	1891	3	tonged
tonger	7	47	1969	3	tonger
tonging	9	33	1451	3	tonging
tongmen	10	3	712	3	tongmen
tongs	6	59	2847	3	tong_s
tongue	7	4	1010	3	tongue
toucan	8	3	819	3	toucan
unban	7	21	1433	3	_unban
unman	7	27	1542	3	_unman
vanman	11	3	979	3	vanman
vegan	9	51	1415	3	_vegan
wangans	11	4	950	3	wangans
wangun	10	3	711	3	wangun
wanigan	11	3	521	3	wanigan
wigan	9	51	1439	3	_wigan
wingman	13	3	638	3	wingman
woman	10	58	1800	3	wo_man
wonton	9	34	1096	3	wonton
yoga	8	74	1805	3	yo_ga_
yogas	9	66	1560	3	yo_gas
yogin	9	83	1774	3	yo_gin
zingani	17	4	481	3	zingani
zingano	17	4	420	3	zingano
zona	13	63	2196	3	zon_a_
zonae	14	51	1644	3	zon_ae
zonal	14	51	1685	3	zon_al

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.466	383457.1
2	DLD Change Limit	112716	418	5.330	21147.5
3	Display Results	418	418	0.140	2985.7
	(SQL Overall)	178691	418	5.936	30102.9