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 “lignin” 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.

370 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
lignin7491119(None) 
lignan75510321lignan
lignins84010491lignins
linin58025521li_nin
aligning10158532aligning
biggin103710602biggin
kinin94917322ki_nin
leggin8268592leggin
ligan67920282lig_an
lignans8398852lignans
lignify1443782lignify
lignite81310302lignite
ligroin848042ligroin
limnic10418832limnic
limning103710312limning
linen55728722li_nen
lining74526802li_ning
linins65922142li_nins
linn46034592li_n_n
lipin75518892li_pin
login66025002log_in
mignon937952mignon
piggin103111092piggin
signing92713962signing
again65218113_again
agin56132713_ag_in
alanin6317273alanin
algin65718763alg_in
aliening91510893aliening
align65016503alig__n
aligned9128553aligned
aligner8108303aligner
aligns75312953align_s
alining81917043ali_ning
bagnio937523bagnio
begin85117353beg_in
biffin14369103biffin
biggie103810933biggie
bigging122815883bigging
biggins113410693biggins
bigwig1333343bigwig
binging113619383binging
binit76431583bi_nit
binning103615453binning
bionic103614573bionic
biotin83215823biotin
blini75519273bli_ni_
blinis85313683bli_nis
chignon1344623chignon
citrin82615403citrin
clinging122910913clinging
clinic104312793cli_nic
coigning1237173coigning
conin76232723_conin
cyanin113911453cyanin
deigning1137753deigning
diamin9312513diamin
diazin1639163diazin
digging113513703digging
digit73825273dig_it
dignify1543893dignify
dignity1236453dignity
digoxin1644943digoxin
dinging103618613dinging
dining84525133di_ning
dinning93416553dinning
dioxin14118783dioxin
eloigning1143453eloigning
fagin9216573fag_in
feigning1335813feigning
fibrin1138533fibrin
ficin103516723fi_cin
figging133313563figging
fining104223213fi_ning
finis86824263fi_nis
finning113615113finning
firkin1337823firkin
flinging133310053flinging
gain56042163__gain
gigging93311773gigging
gin46055753__g_in
ginning93313983ginning
girning93210693girning
gittin72910553gittin
gliadin935593gliadin
grin55733723__grin
guanin7610803guanin
hinging123917103hinging
igging93212063_igging
ignify1334503_ignify
ignite71410573_ignite
inia45024693_i_nia
inion54620173_i_nion
inn36727433_i_n_n
inning73617623_inning
iodin64419343_iodin
ionic74622653_ionic
jigging173011553jigging
jinn115420243ji_n_n
jinni125310633jinni_
jinnis13489053jinnis
kilning12289023kilning
kinging133115033kinging
kingpin1444993kingpin
kinins104014583ki_nins
kirning12319333kirning
lagan66520343lag_an
lagging103316733lagging
lagoon7410483lagoon
lain46146283l__ain
laminin939973laminin
lapin75222923l_apin
lattin64316223lattin
layin84720333l_ayin
leaning83721203leaning
lectin82515013lectin
legging103912643legging
leggins9259473leggins
legion75712983legion
legit61323503leg_it
legman949653legman
legmen939343legmen
legumin1045073legumin
lenis56326863l_enis
leonine7311233leonine
leptin82512333leptin
leucin839113leucin
levin84816413l_evin
liana53915893lian_a
lianas63713383lianas
liane54720663lian_e
lianes63819323lianes
liang64914413lian_g
liangs74410593liangs
lianoid837523lianoid
libri74610113libri_
lichen114012743lichen
lichenin1345053lichenin
lichi104412953lichi_
lichis115212593lichis
licit74327683li_cit
licking144118283licking
lidding103611423lidding
lien45339803li__en
lienal63912783lienal
liens56525503lien_s
lifting113313273lifting
ligand85011293ligand
ligands9438983ligands
ligans76817733ligans
ligase7259913ligase
ligate72519243ligate
ligating102212283ligating
ligation92313093ligation
liger65024463lig_er
ligers75022023ligers
light94429603lig_ht
lighten112811523lighten
lighting132811833lighting
lightning14286023lightning
lights104519913lights
lignites9129603lignites
lignitic1146393lignitic
ligroine945693ligroine
ligroins946823ligroins
ligula7359673ligula
ligule74010833ligule
ligure7279473ligure
liken911818843li_ken
likening13246893likening
liking114319583liking
lilting83515383lilting
liman75921603li_man
limbi96513793limbi_
limbic12528723limbic
limbing123410403limbing
limen75426033li_men
limina83514493limina
liming94021233liming
limit73126333li_mit
limn66527693li__mn
limned94811473limned
limner84112863limner
limns75718393limn_s
limpid11389743limpid
limping124614103limping
limpkin1534223limpkin
lin37967373l___in
linac7315413li_nac
linden7411453linden
lindy96918313li_ndy
line46965573li_n_e
lined64934643li_ned
linens64818393li_nens
lineny94011433li_neny
liner55938913li_ner
lines57054573li_nes
liney87029623li_ney
ling57447963li_n_g
linga66820813li_nga
lingam95112333lingam
lingas75116563lingas
linger75225993linger
lingier84113373lingier
lingo66022103li_ngo
lings67135773li_ngs
lingua7509903lingua
linguine937583linguine
linguini945523linguini
lingy96925133li_ngy
linier64423783li_nier
linings84313073li_nings
link86943443li_n_k
linking123818253linking
links96430193li_nks
linky127622383li_nky
linnet6419413linnet
linns56123333li_nns
lino46343373li_n_o
linos55631503li_nos
lins47059053li_n_s
lint416266233li_n_t
linting83820983linting
lints57137193li_nts
linty87126563li_nty
linum7313823li_num
liny78141323li_n_y
lion46334443li__on
lionise7310373lionise
lionize1668823lionize
lions55923213lion_s
lipid85916173li_pid
lipins85016883lipins
lipoid9411043lipoid
lippen103911403lippen
lipping123016073lipping
liquid1637143liquid
liri45128253li_ri_
lisping103412753lisping
listen64816813listen
listing84020593listing
litai55216363litai_
lithia939333lithia
lithic1139493lithic
litten64014873litten
liven85021733li_ven
livening12248153livening
livid96714423li_vid
living104318323living
loaning83614833loaning
logan68123283log_an
logania847833logania
loggia8457053loggia
loggie84011993loggie
logging103316803logging
logia68116603log_ia
logic88217833log_ic
logins77820643logins
logion76013723logion
logoi69715943logoi_
logon615922313log_on
loin46838723l__oin
lomein8410203lomein
longan75612363longan
longing93915783longing
loonie64216453loonie
lorgnon844423lorgnon
lugeing9359113lugeing
luggie8318903luggie
lugging104114353lugging
luging83915293luging
lungan74710213lungan
lungi65516053lungi_
lunging93714213lunging
lungis77113023lungis
lupin75215843l_upin
lutein6311263lutein
lysin84512783l_ysin
maligning13145583maligning
mignons1037863mignons
mini65634543mi_ni_
minim97321593mi_nim
mining94225443mi_ning
minion83416233mi_nion
minis75432983mi_nis
mirin75023143mi_rin
niacin8310223niacin
nighing123410063nighing
ninon55517383ni_non
noggin8288883noggin
origin7311033orig_in
pianic103714123pianic
picnic123410263picnic
pidgin10259813pidgin
pigeon949413pigeon
piggie103210773piggie
pigging123614673pigging
piggins113010473piggins
pignus937953pignus
pignut9311573pignut
pigpen1136583pigpen
pigskin1444353pigskin
pinging113419553pinging
pining93726533pi_ning
pinion83815893pi_nion
pinning103417853pinning
pinon76024533pi_non
pinyin112710613pinyin
pionic103515953pionic
pipkin14248603pipkin
pippin92810303pippin
quinin152811953quinin
regain74517763regain
reigning1039883reigning
renin54830033_renin
rennin63914033rennin
ricin74620213ri_cin
rigging103016333rigging
rigid7913893rig_id
ringing93521283ringing
rinning83216743rinning
segni63712483segni_
siganid947183siganid
sighing123311663sighing
sigil63515503sig_il
sign55523053sig__n
signa66114703sign_a
signal73711483signal
signed83413753signed
signee73617233signee
signer74015623signer
signet73621153signet
signify1444853signify
signior835043signior
signor73510353signor
signs65516323sign_s
simlin8311723simlin
singing93221423singing
sinning83918443sinning
siskin1079783siskin
slinging103312863slinging
tannin62613923tannin
thionin1048653thionin
tiepin839343tiepin
tiffin12327933tiffin
tiglon737913tiglon
tigon63914443tig_on
tinging93619443tinging
tining74927543ti_ning
tinning83117283tinning
venin85118663_venin
vigia94813273vig_ia
vigil94313003vig_il
vinic10314973vi_nic
vining104619463vi_ning
violin9311983violin
virgin1038083virgin
wienie9229973wienie
wigan95114393wig_an
wigeon1037223wigeon
wigging133413833wigging
wimmin1336143wimmin
winging123718713winging
wining103625053wi_ning
winning113516553winning
within123611383within
yogin98317743yog_in
zigging193210533zigging
zinging183513943zinging
zinnia1536013zinnia

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.1431249587.4
2DLD Change Limit1127163707.40615219.6
3Display Results3703700.373992.0
 (SQL Overall)1786913707.92222556.3
 
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.