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

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

340 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
ligand	8	50	1129	(None)
ligan	6	79	2028	1	ligan_
ligands	9	43	898	1	ligands
ligans	7	68	1773	1	ligans
brigand	11	3	664	2	brigand
lagan	6	65	2034	2	lagan_
lagans	7	57	1778	2	lagans
lagend	8	3	874	2	lagend
land	5	63	3730	2	l__and
legend	8	3	769	2	legend
liana	5	39	1589	2	li_ana
liane	5	47	2066	2	li_ane
liang	6	49	1441	2	li_ang
liard	6	54	1859	2	li_ard
ligase	7	25	991	2	ligase
ligate	7	25	1924	2	ligate
ligated	9	24	1413	2	ligated
lignan	7	55	1032	2	lignan
lignans	8	39	885	2	lignans
liman	7	59	2160	2	liman_
limans	8	48	1630	2	limans
litany	9	3	905	2	litany
lizard	16	36	923	2	lizard
logan	6	81	2328	2	logan_
logans	7	63	1906	2	logans
riband	9	23	962	2	riband
siganid	9	4	718	2	siganid
viand	9	5	1107	2	vi_and
wigan	9	51	1439	2	wigan_
wigans	10	45	1170	2	wigans
aland	6	55	2641	3	_aland
alidad	8	3	887	3	alida_d
align	6	50	1650	3	alig_n_
aligned	9	12	855	3	aligned
aligns	7	53	1295	3	alig_ns
and	4	72	4416	3	___and
augend	8	3	763	3	augend
band	7	67	4090	3	__band
began	8	63	1957	3	began_
bigamy	14	3	633	3	bigamy
bind	7	62	3450	3	bi__nd
bland	8	53	2045	3	_bland
blind	8	63	1932	3	bli__nd
bogan	8	75	1900	3	bogan_
bogans	9	57	1481	3	bogans
brand	8	51	2449	3	_brand
brigands	12	4	562	3	brigands
cigar	8	9	1179	3	ciga_r
cigars	9	9	1071	3	cigars
demand	10	43	1425	3	demand
desand	8	48	1263	3	desand
digamy	13	3	588	3	digamy
digged	10	43	1465	3	digged
disband	11	3	824	3	disband
divan	9	61	1484	3	divan_
divans	10	46	1239	3	divans
diwan	9	57	1255	3	diwan_
diwans	10	51	1037	3	diwans
egad	6	42	1541	3	_ega_d
eland	6	58	2039	3	_eland
elegant	8	3	1150	3	elegant
errand	7	5	879	3	errand
expand	16	23	657	3	expand
fiend	9	53	1298	3	fi_end
figged	12	40	1389	3	figged
find	8	75	3260	3	fi__nd
gad	5	75	5665	3	__ga_d
gaed	6	60	3151	3	__gaed
gan	4	80	6012	3	__gan_
gane	5	51	4529	3	__gane
gang	6	60	3196	3	__gang
gaud	6	70	2543	3	__gaud
giant	6	54	3059	3	gi_ant
giga	6	67	2094	3	giga__
gigas	7	54	1558	3	giga_s
gigged	10	41	1229	3	gigged
gitano	7	3	804	3	gitano
gland	7	52	1771	3	_gland
grand	7	51	2269	3	_grand
hand	8	68	3370	3	__hand
highland	16	11	452	3	highland
hind	8	55	2975	3	hi__nd
hogan	9	78	1770	3	hogan_
hogans	10	59	1431	3	hogans
igged	8	60	1276	3	_igged
iguana	7	3	580	3	_iguana
iguanid	9	4	454	3	_iguanid
iliad	6	46	1345	3	ilia_d
inane	5	28	2034	3	_inane
inland	7	3	1031	3	inland
island	7	3	853	3	island
jigged	16	44	1277	3	jigged
jihad	16	3	591	3	jiha_d
kiang	10	48	1135	3	ki_ang
kind	9	61	2855	3	ki__nd
lad	4	81	6570	3	l__a_d
lagends	9	4	727	3	lagends
laggard	10	34	762	3	laggard
lagged	9	55	2013	3	lagged
laguna	7	12	722	3	laguna
lagune	7	15	863	3	lagune
laid	5	64	3914	3	l__aid
lalland	8	38	1017	3	lalland
lands	6	54	2690	3	l__ands
lane	4	51	5332	3	l__ane
lang	5	66	3737	3	l__ang
lank	8	47	3444	3	l__ank
lard	5	67	4200	3	l__ard
largando	10	4	380	3	largando
lauan	5	52	1679	3	lauan_
lauans	6	51	1353	3	lauans
laud	5	65	2772	3	l__aud
lead	5	60	3885	3	l_ea_d
lean	4	63	4524	3	l_ean_
leaned	7	34	2254	3	l_eaned
leans	5	55	3625	3	l_eans
leant	5	67	3778	3	l_eant
legacy	12	5	665	3	legacy
legal	6	57	1594	3	lega_l
legals	7	34	1273	3	legals
legate	7	29	1745	3	legate
legated	9	25	1398	3	legated
legato	7	28	1095	3	legato
legends	9	3	607	3	legends
legged	9	57	1308	3	legged
legman	9	4	965	3	legman_
legong	8	3	696	3	legong
leman	7	56	2260	3	leman_
lemans	8	53	1639	3	lemans
lend	5	62	3367	3	l__end
levant	9	3	1449	3	levant
lianas	6	37	1338	3	li_anas
lianes	6	38	1932	3	li_anes
liangs	7	44	1059	3	li_angs
lianoid	8	3	752	3	li_anoid
liar	4	72	2968	3	li_a_r
liards	7	52	1261	3	li_ards
liars	5	47	2316	3	li_ars
licked	13	46	2156	3	licked
lid	4	74	5351	3	li___d
lidar	6	3	1272	3	lida_r
lidars	7	3	1078	3	lidars
lidded	9	34	1024	3	lidded
lied	5	58	3809	3	li__ed
lien	4	53	3980	3	li_en_
lienal	6	39	1278	3	lienal
liens	5	65	2550	3	li_ens
lierne	6	3	802	3	lierne
lifted	10	44	1352	3	lifted
ligament	11	4	930	3	ligament
ligases	8	23	1070	3	ligases
ligates	8	23	1837	3	ligates
ligating	10	22	1228	3	ligating
liger	6	50	2446	3	lig_er
ligers	7	50	2202	3	ligers
light	9	44	2960	3	lig_ht
lighted	12	29	1350	3	lighted
lights	10	45	1991	3	lights
lignin	7	49	1119	3	lignin
lignins	8	40	1049	3	lignins
ligula	7	35	967	3	ligula
ligule	7	40	1083	3	ligule
ligure	7	27	947	3	ligure
liked	10	45	2381	3	li_ked
liken	9	118	1884	3	liken_
likened	12	26	735	3	likened
likens	10	56	1370	3	likens
liking	11	43	1958	3	liking
lilac	7	3	1107	3	lila_c
lilacs	8	3	748	3	lilacs
lilied	7	39	1321	3	lilied
lilted	7	37	1537	3	lilted
lima	6	57	3413	3	lima__
limas	7	56	2763	3	lima_s
limbed	11	45	1317	3	limbed
limed	8	54	2680	3	li_med
limen	7	54	2603	3	limen_
limens	8	46	1803	3	limens
limina	8	35	1449	3	limina
liming	9	40	2123	3	liming
limn	6	65	2769	3	li_mn_
limned	9	48	1147	3	limned
limns	7	57	1839	3	li_mns
limped	11	48	1712	3	limped
limpid	11	38	974	3	limpid
lin	3	79	6737	3	li__n_
linac	7	3	1541	3	lina_c
linacs	8	3	1081	3	linacs
linage	7	7	1340	3	linage
lindane	8	3	902	3	lindane
lindy	9	69	1831	3	li__ndy
line	4	69	6557	3	li__ne
lined	6	49	3464	3	li_ned
linen	5	57	2872	3	linen_
linens	6	48	1839	3	linens
lineny	9	40	1143	3	lineny
ling	5	74	4796	3	li__ng
linga	6	68	2081	3	linga__
lingam	9	51	1233	3	linga_m
lingams	10	45	1017	3	lingams
lingas	7	51	1656	3	linga_s
lingcod	11	4	368	3	lingcod
linin	5	80	2552	3	linin_
lining	7	45	2680	3	lining
linins	6	59	2214	3	linins
link	8	69	4344	3	li__nk
linked	11	45	1821	3	linked
linn	4	60	3459	3	li__nn
linns	5	61	2333	3	li_nns
lino	4	63	4337	3	li__no
lins	4	70	5905	3	li__ns
linsang	8	3	586	3	linsang
lint	4	162	6623	3	li__nt
linted	7	40	2182	3	linted
liny	7	81	4132	3	li__ny
lion	4	63	3444	3	li_on_
lions	5	59	2321	3	li_ons
lipa	6	84	2592	3	lipa__
lipase	8	23	910	3	lipase
lipid	8	59	1617	3	li_pid
lipin	7	55	1889	3	lipin_
lipins	8	50	1688	3	lipins
lipoid	9	4	1104	3	lipoid
lipped	11	44	1954	3	lipped
liquid	16	3	714	3	liquid
lira	4	69	2868	3	lira__
liras	5	60	2198	3	lira_s
lisped	9	41	1342	3	lisped
listed	7	43	2283	3	listed
litai	5	52	1636	3	lita_i
litas	5	49	2377	3	lita_s
litigant	9	4	687	3	litigant
lived	9	55	2372	3	li_ved
liven	8	50	2173	3	liven_
livened	11	23	893	3	livened
livens	9	43	1489	3	livens
livid	9	67	1442	3	li_vid
living	10	43	1832	3	living
lizards	17	42	761	3	lizards
llano	5	9	1060	3	l_lano
load	5	67	3060	3	l_oa_d
loan	4	74	3645	3	l_oan_
loaned	7	38	1629	3	l_oaned
loans	5	60	2646	3	l_oans
logania	8	4	783	3	logania
logged	9	66	2294	3	logged
login	6	60	2500	3	login_
logins	7	78	2064	3	logins
logon	6	159	2231	3	logon_
logons	7	98	1817	3	logons
longan	7	56	1236	3	longan_
longans	8	45	1081	3	longans
longhand	13	4	449	3	longhand
loran	5	59	2509	3	loran_
lorans	6	51	1760	3	lorans
lowland	11	3	469	3	lowland
luged	7	40	1909	3	lug_ed
lugged	9	44	1705	3	lugged
luging	8	39	1529	3	luging
lungan	7	47	1021	3	lungan_
lungans	8	39	905	3	lungans
lyard	9	51	1321	3	l_yard
midland	11	3	660	3	midland
migrant	10	3	1431	3	migrant
mind	7	54	3436	3	mi__nd
misadd	10	3	716	3	misadd
nagana	7	4	894	3	nagana
nicad	8	3	1261	3	nica_d
niggard	10	4	494	3	niggard
nighed	11	38	1129	3	nighed
organ	6	9	1539	3	organ_
organa	7	8	921	3	organa
organdy	12	5	457	3	organdy
organs	7	9	1291	3	organs
origan	7	3	1069	3	origan_
origans	8	3	997	3	origans
pagan	8	61	2116	3	pagan_
pagans	9	57	1792	3	pagans
pian	6	61	3609	3	pi_an_
piano	7	61	1871	3	pi_ano
pians	7	51	2696	3	pi_ans
pigged	11	42	1415	3	pigged
pinang	9	26	1159	3	pinang
pirana	8	7	1326	3	pirana
pliant	8	39	1882	3	pli_ant
rand	5	58	3956	3	__rand
regard	8	52	1577	3	regard
reland	7	59	2043	3	reland
remand	9	56	1896	3	remand
repand	9	53	1606	3	repand
riant	5	58	3315	3	ri_ant
ribald	9	20	929	3	ribald
ribands	10	20	839	3	ribands
ribband	12	4	558	3	ribband
rigged	9	45	1740	3	rigged
rigid	7	9	1389	3	rig_id
rimland	10	3	566	3	rimland
rind	5	65	3560	3	ri__nd
ritard	7	48	1208	3	ritard
roband	9	23	1072	3	roband
sand	5	53	3846	3	__sand
siganids	10	4	530	3	siganids
sighed	11	37	1205	3	sighed
sign	5	55	2305	3	sig_n_
signa	6	61	1470	3	sig_na
signal	7	37	1148	3	signal
signed	8	34	1375	3	signed
signs	6	55	1632	3	sig_ns
silane	6	27	1805	3	silane
slogan	7	53	922	3	slogan_
slogans	8	40	798	3	slogans
soland	7	51	1504	3	soland
stand	6	59	2328	3	_stand
strand	7	45	1482	3	strand
tigon	6	39	1444	3	tigon_
tigons	7	41	1225	3	tigons
tisane	6	3	1157	3	tisane
titan	5	33	1817	3	titan_
titans	6	34	1491	3	titans
togaed	8	47	1134	3	togaed
tzigane	17	4	293	3	tzigane
unhand	10	4	1038	3	unhand
upland	9	3	886	3	upland
vegan	9	51	1415	3	vegan_
vegans	10	39	1085	3	vegans
viands	10	4	781	3	vi_ands
viga	8	56	2296	3	viga__
vigas	9	48	1788	3	viga_s
visaed	10	41	1050	3	visaed
visard	10	39	1012	3	visard
vizard	19	45	885	3	vizard
wand	8	58	3387	3	__wand
wigged	12	44	1358	3	wigged
wind	8	55	3385	3	wi__nd
witan	8	38	1650	3	witan_
witans	9	34	1293	3	witans
wizard	19	37	771	3	wizard
zigged	18	41	1019	3	zigged
zingani	17	4	479	3	zingani
zingano	17	4	419	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	112716	0.266	671770.7
2	DLD Change Limit	112716	340	6.876	16392.7
3	Display Results	340	340	0.123	2764.2
	(SQL Overall)	178691	340	7.265	24596.1