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

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

322 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
longans	8	45	1081	(None)
logans	7	63	1906	1	lo_gans
longan	7	56	1236	1	longan_
lungans	8	39	905	1	lungans
bogans	9	57	1481	2	bo_gans
congas	9	44	1703	2	conga_s
dongas	8	49	1461	2	donga_s
hogans	10	59	1431	2	ho_gans
honans	9	48	1450	2	hon_ans
lagans	7	57	1778	2	l_agans
ligans	7	68	1773	2	l_igans
lignans	8	39	885	2	lignans
lingams	10	45	1019	2	lingams
lingas	7	51	1657	2	linga_s
loans	5	60	2646	2	lo__ans
lochans	12	4	883	2	lochans
logan	6	81	2328	2	lo_gan_
loggats	9	28	645	2	loggats
logins	7	78	2064	2	lo_gins
logons	7	98	1817	2	lo_gons
longers	8	48	1954	2	longers
longes	7	59	2557	2	long_es
longhand	13	4	449	2	longhand
longhands	14	4	361	2	longhands
longies	8	29	1655	2	longies
longing	9	39	1578	2	longing
longings	10	40	856	2	longings
longs	6	55	2706	2	long__s
longways	15	4	387	2	longways
lorans	6	51	1760	2	lo_rans
lungan	7	47	1021	2	lungan_
morgans	10	3	1012	2	morgans
nonfans	10	3	753	2	nonfans
nongays	11	17	653	2	nongays
organs	7	9	1291	2	_organs
slogans	8	40	798	2	slo_gans
tongas	7	43	1552	2	tonga_s
wangans	11	4	950	2	wangans
angas	6	58	2798	3	_anga_s
banians	9	3	1203	3	banians
banyans	12	3	791	3	banyans
blowguns	14	4	216	3	blowguns
bogan	8	75	1900	3	bo_gan_
bonbons	11	3	933	3	bonbons
bonging	11	33	1637	3	bonging
bongoes	10	43	1411	3	bongoes
bongos	9	53	1665	3	bong_os
bongs	8	78	2842	3	bong__s
brogans	10	4	966	3	brogans
cancans	11	3	1187	3	cancans
cognacs	12	5	604	3	cognacs
cogons	9	68	1811	3	co_gons
coigns	9	44	1006	3	coig_ns
confabs	14	3	539	3	confabs
conga	8	54	1987	3	conga__
congaed	11	39	974	3	congaed
congaing	12	3	982	3	congaing
congeals	11	30	985	3	congeals
congees	10	35	1792	3	congees
congers	10	42	2323	3	congers
conges	9	49	2817	3	cong_es
congius	10	32	1007	3	congius
congoes	10	36	1730	3	congoes
congos	9	42	1988	3	cong_os
congous	10	36	1508	3	congous
congrats	11	3	1143	3	congrats
conins	8	43	2723	3	con_ins
conns	7	50	2423	3	con__ns
contains	10	3	1653	3	contains
cooncans	12	4	627	3	cooncans
corbans	11	3	1317	3	corbans
cotans	8	13	1792	3	co_tans
cougars	10	3	844	3	cougars
dognaps	11	3	439	3	dognaps
dolmans	10	47	968	3	dolmans
donas	6	59	2647	3	don_a_s
donga	7	67	1842	3	donga__
dongles	9	32	1287	3	dongles
dongs	7	65	2581	3	dong__s
donjons	15	3	673	3	donjons
donnas	7	55	1132	3	donna_s
eloigns	8	42	535	3	eloig_ns
elongate	9	4	561	3	elongate
elongates	10	4	538	3	elongates
eonian	6	3	1183	3	eonian_
fangas	10	50	1719	3	fanga_s
flongs	10	50	1049	3	flong__s
fondant	11	3	1114	3	fondant
fondants	12	4	620	3	fondants
fungals	11	27	678	3	fungals
gingals	9	10	931	3	gingals
glonoins	9	5	584	3	glonoins
gobans	9	44	1204	3	go_bans
gonads	8	45	1173	3	gon_ads
gonging	10	37	1303	3	gonging
gongs	7	49	2161	3	gong__s
gorgons	9	3	885	3	gorgons
gossans	8	3	678	3	gossans
gowans	10	55	1229	3	go_wans
hangars	11	43	1349	3	hangars
hogan	9	78	1770	3	ho_gan_
honan	8	53	1977	3	hon_an_
hondas	10	3	1335	3	honda_s
hongies	11	27	1647	3	hongies
hongs	9	51	2620	3	hong__s
ionogens	9	5	682	3	ionogens
jingals	15	8	807	3	jingals
jordans	15	6	683	3	jordans
kanbans	13	3	772	3	kanbans
klongs	11	43	660	3	klong__s
koans	9	58	1862	3	ko__ans
kurgans	12	14	565	3	kurgans
lagan	6	65	2034	3	l_agan_
lallans	7	41	1353	3	lallans
lanais	6	3	1679	3	lan_ais
landaus	8	3	1034	3	landaus
langshans	13	4	428	3	langshans
langues	8	12	1191	3	langues
langurs	8	8	910	3	langurs
lantana	7	3	960	3	lantana
lantanas	8	3	826	3	lantanas
laogais	8	4	581	3	laogais
lauans	6	51	1353	3	l_auans
leans	5	55	3625	3	l__eans
legals	7	34	1273	3	l_egals
leggins	9	25	947	3	leggins
lemans	8	53	1639	3	l_emans
lengths	11	4	408	3	lengths
ligan	6	79	2028	3	l_igan_
ligand	8	50	1129	3	l_igand
ligands	9	43	898	3	l_igands
lignan	7	55	1032	3	lignan_
lignins	8	40	1049	3	lignins
limans	8	48	1630	3	l_imans
linacs	8	3	1081	3	lin_acs
linages	8	8	1317	3	linages
lindane	8	3	903	3	lindane
lindanes	9	3	917	3	lindanes
lindens	8	3	941	3	lindens
linens	6	48	1839	3	lin_ens
linga	6	68	2082	3	linga__
lingam	9	51	1235	3	linga_m
lingers	8	42	2330	3	lingers
lingoes	8	40	1469	3	lingoes
lings	6	71	3577	3	ling__s
linguals	9	31	722	3	linguals
linins	6	59	2214	3	lin_ins
linns	5	61	2333	3	lin__ns
linsang	8	3	586	3	linsang
linsangs	9	4	441	3	linsangs
loads	6	53	2337	3	lo__ads
loafs	8	56	1699	3	lo__afs
loams	7	56	1986	3	lo__ams
loan	4	74	3645	3	lo__an_
locals	8	37	1450	3	lo_cals
lochan	11	3	909	3	lochan_
lodens	7	43	1506	3	lo_dens
lodgers	9	51	1383	3	lodgers
lodges	8	68	2015	3	lodg_es
lodging	10	31	1081	3	lodging
lodgings	11	33	624	3	lodgings
logania	8	4	783	3	lo_gania
loges	6	65	3420	3	lo_g_es
loggers	9	46	1613	3	loggers
loggets	9	37	891	3	loggets
loggias	9	35	678	3	loggias
logging	10	33	1680	3	logging
loggings	11	39	823	3	loggings
logics	9	57	1112	3	lo_gics
login	6	60	2500	3	lo_gin_
logions	8	62	1129	3	logions
logjams	17	4	358	3	logjams
logon	6	159	2231	3	lo_gon_
logos	6	72	2533	3	lo_g_os
logs	5	73	4311	3	lo_g__s
logways	14	3	451	3	logways
loins	5	67	2842	3	lo__ins
lomeins	9	6	948	3	lomeins
loners	6	42	2581	3	lon_ers
long	5	69	3334	3	long___
longboats	12	4	392	3	longboats
longbow	13	4	386	3	longbow
longbows	14	4	388	3	longbows
longe	6	66	2646	3	long__e
longed	8	71	2137	3	long_ed
longeing	10	17	759	3	longeing
longer	7	58	2320	3	long_er
longerons	10	4	589	3	longerons
longest	8	41	1495	3	longest
longhair	12	4	267	3	longhair
longhairs	13	4	273	3	longhairs
longheads	14	4	423	3	longheads
longhorns	13	4	413	3	longhorns
longish	11	22	909	3	longish
longline	9	3	876	3	longline
longlines	10	4	798	3	longlines
longly	10	27	960	3	long_ly
longness	9	3	855	3	longness
longwise	12	4	408	3	longwise
loofahs	13	36	462	3	loofahs
loofas	9	42	983	3	loofa_s
loons	5	57	3172	3	lo__ons
loosens	7	163	1095	3	loosens
loquats	16	4	527	3	loquats
loran	5	59	2509	3	lo_ran_
lorgnons	9	4	399	3	lorgnons
lotahs	9	47	987	3	lo_tahs
lotas	5	59	2630	3	lo_ta_s
lotions	7	46	1476	3	lotions
loudens	8	36	805	3	loudens
loughs	10	50	1477	3	loug_hs
loumas	8	48	1233	3	louma_s
loungers	9	44	900	3	loungers
lounges	8	48	1135	3	loung_es
lounging	10	3	675	3	lounging
lovages	11	3	803	3	lovages
lovats	9	3	907	3	lo_vats
lowland	11	3	469	3	lowland
lowlands	12	4	437	3	lowlands
lunars	6	50	1281	3	lun_ars
lunas	5	50	2501	3	lun_a_s
lungees	8	44	1214	3	lungees
lungers	8	38	1709	3	lungers
lunges	7	61	2342	3	lung_es
lunging	9	37	1421	3	lunging
lungis	7	71	1302	3	lung_is
lungs	6	52	2388	3	lung__s
lungyis	11	29	410	3	lungyis
lurdans	8	3	707	3	lurdans
mangas	9	41	2292	3	manga_s
mannans	9	36	1152	3	mannans
minyans	12	3	726	3	minyans
moans	7	46	2437	3	mo__ans
monads	9	45	1530	3	mon_ads
monas	7	47	3215	3	mon_a_s
monerans	10	3	1034	3	monerans
mongers	10	42	1727	3	mongers
mongoes	10	34	1571	3	mongoes
mongols	10	33	1082	3	mongols
mongos	9	43	1862	3	mong_os
montane	9	13	1362	3	montane
montanes	10	11	1452	3	montanes
morgan	9	3	1137	3	morgan_
morgens	10	3	1046	3	morgens
naans	5	58	1525	3	__naans
nans	4	61	3940	3	__n_ans
noggins	9	28	845	3	noggins
nonages	8	3	1384	3	nonages
nonagons	9	4	722	3	nonagons
nonas	5	51	2665	3	non_a_s
nonbank	13	4	590	3	nonbank
nonbanks	14	4	503	3	nonbanks
nonfan	9	4	829	3	nonfan_
nongame	10	3	818	3	nongame
nongay	10	16	915	3	nonga_y
nonman	8	4	1236	3	nonman_
nonpagans	12	4	383	3	nonpagans
nonwars	10	10	900	3	nonwars
nougats	8	42	741	3	nougats
oceans	8	12	1100	3	_oceans
octans	8	14	1114	3	_octans
ogams	8	41	1268	3	_o_gams
onions	6	40	1643	3	_onions
onlays	9	39	871	3	_onlays
organ	6	9	1539	3	_organ_
organa	7	8	921	3	_organa
origans	8	3	997	3	origans
pagans	9	57	1792	3	_pagans
pangas	9	99	2110	3	panga_s
pangens	10	31	1206	3	pangens
pongees	10	42	1254	3	pongees
pongids	11	34	741	3	pongids
ponging	11	34	1615	3	ponging
pongs	8	55	2634	3	pong__s
pontons	9	33	1555	3	pontons
popguns	12	3	402	3	popguns
randans	8	3	1321	3	randans
roans	5	49	2644	3	ro__ans
romans	8	46	2024	3	ro_mans
ronions	7	33	1334	3	ronions
rontgens	9	4	468	3	rontgens
ronyons	10	25	843	3	ronyons
rowans	9	57	1534	3	ro_wans
sangars	8	31	1625	3	sangars
sangas	7	52	2265	3	sanga_s
slogan	7	53	922	3	slo_gan_
solans	6	41	2249	3	so_lans
soldans	8	32	1040	3	soldans
somans	8	46	1930	3	so_mans
sonant	6	6	2195	3	son_ant
sonants	7	5	1123	3	son_ants
sonars	6	48	1897	3	son_ars
songs	6	77	2555	3	song__s
soudans	8	30	935	3	soudans
sovrans	10	3	648	3	sovrans
sowans	9	42	1589	3	so_wans
spongins	11	3	656	3	spongins
suntans	7	21	1173	3	suntans
syngas	10	36	891	3	synga_s
togas	6	78	2300	3	to_ga_s
tolans	6	43	1927	3	to_lans
tomans	8	54	1913	3	to_mans
tonga	6	56	1969	3	tonga__
tongers	8	41	1601	3	tongers
tonging	9	33	1451	3	tonging
tongman	10	3	757	3	tongman_
tongs	6	59	2846	3	tong__s
tongues	8	7	969	3	tongues
toucans	9	3	758	3	toucans
unbans	8	19	1262	3	_unbans
unmans	8	22	1199	3	_unmans
vegans	10	39	1085	3	_vegans
wangan	10	3	1122	3	wangan_
wanguns	11	3	502	3	wanguns
wanigans	12	4	474	3	wanigans
wigans	10	45	1170	3	_wigans
womans	11	46	1365	3	wo_mans
wontons	10	33	1053	3	wontons
yogas	9	66	1560	3	yo_ga_s
yogins	10	51	1410	3	yo_gins
zingani	17	4	481	3	zingani
zingano	17	4	420	3	zingano

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	134027	0.420	425454.8
2	DLD Change Limit	134027	322	6.580	20368.8
3	Display Results	322	322	0.110	2927.3
	(SQL Overall)	178691	322	7.110	25132.3