Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

Here are the results of your fuzzy-string dictionary search for “lignan” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

296 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
lignan7551032(None) 
ligan67920281lig_an
lignans8398851lignans
lignin74911191lignin
lagan66520342lag_an
legman949652legman
liana53915892liana_
lianas63713382lianas
lienal63912782lienal
ligand85011292ligand
ligans76817732ligans
lignins84010492lignins
liman75921602li_man
linac7315412li_nac
linen55728722li_nen
linga66820812linga_
lingam95112332lingam
lingas75116562lingas
linin58025522li_nin
linn46034592li_n_n
logan68123282log_an
longan75612362longan
lungan74710212lungan
mignon937952mignon
signa66114702signa_
signal73711482signal
wigan95114392wig_an
afghan1333873afghan
aidman92410623aidman
airman82414223airman
align65016503alig__n
aligned9128553aligned
aligner8108303aligner
aligning10158533aligning
aligns75312953align_s
bagman114613813bagman
began86319573beg_an
biggin103710603biggin
binal75323823bi_nal
bogan87519003bog_an
chignon1344623chignon
cigar8911793cig_ar
clinal8311553cli_nal
cognac1157273cognac
dinar66319893di_nar
dioxan1465773dioxan
dipnoan1044653dipnoan
divan96114843di_van
diwan95712553di_wan
dognap1035343dognap
epigean1045503epigean
final83922033fi_nal
firman112211343firman
flagman13186173flagman
gagman103811243gagman
gan48060123__g_an
giga66720943gig_a_
gigas75415583gig_as
gingal81010143gingal
gnar56021383__gnar
gnat56034433__gnat
gnaw86515743__gnaw
gnawn9517783__gnawn
gran56335013__gran
guan55325583__guan
hitman112710213hitman
hogan97817703hog_an
honan85319773_honan
iguana735803_iguana
inane52820343_i_nane
inn36727433_i_n_n
jigsaw1742493jigsaw
jigsawn1841583jigsawn
jingal1498583jingal
jinn115420243ji_n_n
kidnap1334193kidnap
kina85631993ki_na_
kinas95626913ki_nas
kinin94917323ki_nin
lagans75717783lagans
lagoon7410483lagoon
laguna7127223laguna_
lagunas8156823lagunas
lallan63414173lallan
lanai5319573l_anai
lauan55216793l_auan
lawman11289053lawman
layman113511303layman
lean46345243l__ean
legal65715943leg_al
leggin8268593leggin
legion75712983legion
legmen939343legmen
leman75622603l_eman
liane54720663lian_e
lianes63819323lianes
liang64914413lian_g
liangs74410593liangs
liar47229683li__ar
liblab1035083liblab
libra74712423libra_
librae84310173librae
libras83711703libras
lichen114012743lichen
lidar6312723li_dar
liegeman1143333liegeman
lien45339803li__en
liens56525503lien_s
liftman1244063liftman
ligands9438983ligands
ligase7259913ligase
ligate72519243ligate
liger65024463lig_er
ligers75022023ligers
light94429603lig_ht
lighten112811523lighten
lights104519913lights
lignify1443783lignify
lignite81310303lignite
ligroin848043ligroin
ligula7359673ligula
ligulae8308753ligulae
ligular8348533ligular
ligulas8329163ligulas
ligule74010833ligule
ligure7279473ligure
liken911818843li_ken
lilac7311073li_lac
lima65734133li_ma_
limans84816303limans
limas75627633li_mas
limba95414973limba_
limbas105313193limbas
limen75426033li_men
limina83514493limina_
liminal93810673liminal
limn66527693li__mn
limned94811473limned
limner84112863limner
limnic10418833limnic
limning103710313limning
limns75718393limn_s
limpa97014463limpa_
limpas105513083limpas
lin37967373li___n
linacs8310813li_nacs
linage7713403li_nage
lindane839023lindane
linden7411453linden
lindy96918313li_ndy
line46965573li_n_e
lineal65616023lineal
linear65113333linear
lined64934643li_ned
lineman939113lineman
linens64818393li_nens
lineny94011433li_neny
liner55938913li_ner
lines57054573li_nes
liney87029623li_ney
ling57447963li_n_g
lingams104510173lingams
linger75225993linger
lingo66022103li_ngo
lings67135773li_ngs
lingua7509903lingua
linguae8398393linguae
lingual8379073lingual
lingy96925133li_ngy
lining74526803li_ning
linins65922143li_nins
link86943443li_n_k
linkman1335383linkman
links96430193li_nks
linky127622383li_nky
linnet6419413linnet
linns56123333li_nns
lino46343373li_n_o
linos55631503li_nos
lins47059053li_n_s
linsang835863linsang
lint416266233li_n_t
lints57137193li_nts
linty87126563li_nty
linum7313823li_num
liny78141323li_n_y
lion46334443li__on
lions55923213lion_s
lipa68425923li_pa_
lipin75518893li_pin
lippen103911403lippen
lira46928683li_ra_
liras56021983li_ras
listen64816813listen
litai55216363li_tai
litany939053litany
litas54923773li_tas
litten64014873litten
liven85021733li_ven
loan47436453l__oan
lochan1139093lochan
logans76319063logans
logia68116603logia_
login66025003log_in
logion76013723logion
logjam1635363logjam
logon615922313log_on
logway1335913logway
longans84510813longans
loran55925093l_oran
lorgnon844423lorgnon
luna46229853l_una_
lunar57017313l_unar
lunas55025013l_unas
lungans8399053lungans
lurdan738363lurdan
magian9312833magian
malignant1245223malignant
mannan85413623mannan
mignons1037863mignons
migrant10314313migrant
mina65136903mi_na_
minae75627723mi_nae
minas75434113mi_nas
minyan1138173minyan
nan37854873___nan
ninon55517383ni_non
oilcan837793oilcan
oilman839483oilman
organ6915393org_an
origan7310693orig_an
pagan86121163pag_an
pian66136093pi__an
pigeon949413pigeon
piggin103111093piggin
pignus937953pignus
pignut9311573pignut
pigpen1136583pigpen
pina65842633pi_na_
pinang92611593pi_nang
pinas75434453pi_nas
pinna75320183pinna_
pinnae84414643pinnae
pinnal84814273pinnal
pinnas85315513pinnas
pinon76024533pi_non
pitman102412123pitman
poignant1145743poignant
raglan73711503raglan
ragman94013713ragman
regna64614813regna_
regnal74812933regnal
regnant8312843regnant
siccan1037593siccan
sienna647193sienna
sigla64515203sigla_
sigma84513823sigma_
sigmas94111353sigmas
sign55523053sig__n
signage937773signage
signals8359163signals
signed83413753signed
signee73617233signee
signer74015623signer
signet73621153signet
signing92713963signing
signor73510353signor
signs65516323sign_s
silvan92810153silvan
simian8811153simian
slogan7539223slog_an
tiglon737913tiglon
tigon63914443tig_on
tinman82411123tinman
titan53318173ti_tan
titian62512663titian
titman82710993titman
vegan95114153veg_an
viga85622963vig_a_
vigas94817883vig_as
vigia94813273vigia_
vigias104110893vigias
vina76331803vi_na_
vinal85725813vi_nal
vinas85126343vi_nas
wangan10311223wangan
wiccan1335033wiccan
wigans104511703wigans
wigeon1037223wigeon
wigwag1443723wigwag
wigwam1544723wigwam
wingman1336363wingman
witan83816503wi_tan
zigzag1642963zigzag
zingani1744793zingani
zingano1744193zingano

Search took 9 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.203880251.2
2DLD Change Limit1127162967.92314226.4
3Display Results2962960.0933182.8
 (SQL Overall)1786912968.21921741.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.