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

355 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
lignins8401049(None) 
lignans8398851lignans
lignin74911191lignin_
linins65922141li_nins
aligning10158532aligning
biggins113410692biggins
kinins104014582ki_nins
leggins9259472leggins
ligans76817732lig_ans
lignan75510322lignan_
lignify1443792lignify
lignite81310302lignite
lignites9129612lignites
ligroins946822ligroins
limning103710322limning
linens64818392li_nens
linin58025522li_nin_
lining74526802li_ning
linings84313072li_nings
linns56123332li_n_ns
lipins85016882li_pins
logins77820642log_ins
mignons1037862mignons
piggins113010472piggins
signing92713962signing
aiblins9311473aiblins
alanins7315803alanins
algins74816433alg_ins
aliening91510893aliening
aligners9117573aligners
aligns75312953alig__ns
alining81917043ali_ning
bagnios1036073bagnios
begins94415303beg_ins
biffins15358533biffins
biggies113813523biggies
biggin103710603biggin_
bigging122815883bigging
biggings13327473biggings
bigness1038193bigness
bigwigs1443003bigwigs
binging113619383binging
binits85716673bi_nits
binning103615453binning
bionics114310873bionics
biotins93114453biotins
blinis85313683bli_ni_s
chignons1444713chignons
citrins92614363citrins
clinging122910913clinging
clinics11338743cli_nics
coigning1237173coigning
conins84327233_conins
cyanins122910013cyanins
deigning1137753deigning
diamins10312213diamins
diazins1739183diazins
digging113513703digging
diggings12316623diggings
digits84114533dig_its
dignify1543893dignify
dignity1236453dignity
digoxins1744293digoxins
dingies93618243dingies
dinging103618613dinging
dining84525133di_ning
dinning93416553dinning
dioxins1568003dioxins
eloigning1143453eloigning
fagins10513863fag_ins
feigning1335813feigning
fibrins1238633fibrins
ficins113513983fi_cins
figging133313563figging
fining104223213fi_ning
finings114311773fi_nings
finis86824263fi_ni_s
finning113615113finning
firkins1437663firkins
flinging133310053flinging
gains65729513__gains
gigging93311773gigging
ginning93313983ginning
ginnings10366523ginnings
gins55543953__g_ins
girning93210693girning
gliadins1035193gliadins
grins65427223__grins
guanins8810013guanins
hinging123917123hinging
hinnies103615103hinnies
igging93212073_igging
ignify1334513_ignify
ignite71410583_ignite
ignites81310583_ignites
inions64417003_i_nions
inning73617633_inning
innings8329443_innings
inns46920933_i_n_ns
iodins74216523_iodins
ionics84214483_ionics
jigging173011553jigging
jinnis13489053jinni_s
jinns126013843ji_n_ns
kilning12289023kilning
kinging133115033kinging
kingpins1544903kingpins
kinin94917323ki_nin_
kirning12319333kirning
lagans75717783lag_ans
lagging103316733lagging
laggings11298403laggings
lagoons839253lagoons
laminins1039133laminins
lapins84520683l_apins
lashins103915153lashins
lattins74115483lattins
layins93817653l_ayins
leaning83721203leaning
leanings94010183leanings
lectins92515003lectins
leggin8268593leggin_
legging103912643legging
leggings11316193leggings
legions84611783legions
legits71313003leg_its
legumins1144993legumins
lenis56326863l_eni_s
leonine7311233leonine
leptins92412693leptins
leucins938103leucins
levins94514653l_evins
lianas63713383lian_as
lianes63819323lian_es
liangs74410593lian_gs
lichenins1444843lichenins
lichens123510683lichens
lichis115212593lichi_s
licking144118283licking
lickings15298143lickings
lidding103611433lidding
liens56525503li__ens
lifting113313273lifting
ligan67920283lig_an_
ligand85011293lig_and
ligands9438983ligands
ligases82310713ligases
ligates82318383ligates
ligating102212283ligating
ligations102111993ligations
ligers75022043lig_ers
lightens122510003lightens
lighting132811833lighting
lightings14277723lightings
lightning14286023lightning
lightnings15263803lightnings
lights104519913lig_hts
ligneous945233ligneous
lignifies1346263lignifies
lignitic1146393lignitic
ligroin848043ligroin_
ligroine945693ligroine
ligroines1044993ligroines
ligulas8329173ligulas
ligules82210923ligules
ligures8269893ligures
likening13246893likening
likens105613703li_kens
liking114319583li_king
likings12539413likings
lilies63021413li_lies
lilting83515383lilting
limans84816303li_mans
limbing123410423limbing
limens84618033li_mens
limina83514503li_mina
liming94021243li_ming
limits82514143li_mits
limners93311563limners
limnic10418843limni_c
limns75718393li__mns
limping124614113limping
limpkins1644233limpkins
linacs8310813li_nacs
lindens839413lindens
lindies8416583lindies
linen55728723li_nen_
lineny94011443li_neny
liners65428853li_ners
lines57054573li_n_es
lingams104510193lingams
lingas75116573li_ngas
lingers84223303lingers
lingier84113383lingier
lingiest93715263lingiest
lingoes84014693lingoes
lings67135773li_n_gs
linguine937593linguine
linguines1046513linguines
linguini945533linguini
linguinis1044283linguinis
linier64423793li_nier
liniest73321153li_niest
linking123818253linking
links96430193li_n_ks
linn46034593li_n_n_
linnets739833linnets
linos55631503li_n_os
lins47059053l___ins
linting83820983linting
lints57137193li_n_ts
linums838283li_nums
lioness739103lioness
lionise7310373lionise
lionises8310313lionises
lionize1668823lionize
lionizes1738773lionizes
lions55923213li__ons
lipids94310923li_pids
lipin75518893li_pin_
lipoids1038233lipoids
lippens11328533lippens
lipping123016073lipping
lippings13296093lippings
liquids1735823liquids
lisping103412753lisping
listens74014133listens
listing84020593listing
listings93310043listings
litanies8310993litanies
lithias1038823lithias
livening12248153livening
livens94314893li_vens
living104318323li_ving
livings11408923livings
loaning83614833loaning
loanings9348013loanings
logans76319063log_ans
loggias9356783loggias
logging103316803logging
loggings11398233loggings
logics95711123log_ics
login66025003log_in_
logions86211293logions
logons79818173log_ons
loins56728423l__oins
lomeins969473lomeins
longans84510813longans
longies82916553longies
longing93915783longing
longings10408563longings
loonies73919543loonies
lorgnons943993lorgnons
lugeing9359113lugeing
luggies93011213luggies
lugging104114353lugging
luging83915293lug_ing
lungans8399053lungans
lunging93714213lunging
lungis77113023lungi_s
lunies64723013l_unies
lupins84514463l_upins
luteins7310103luteins
lysins94610953l_ysins
maligning13145583maligning
mignon937953mignon_
minims104514813mi_nims
mining94225453mi_ning
minings103912073mi_nings
minions93314623mi_nions
minis75432993mi_ni_s
minnies93617363minnies
mirins83918903mi_rins
muggins11248073muggins
niacins938543niacins
nighing123410063nighing
ninnies73713613ninnies
ninons64913773ni_nons
noggins9288453noggins
origins8310463orig_ins
picnics13297343picnics
pidgins11259123pidgins
pigeons1039183pigeons
piggies113813483piggies
piggin103111093piggin_
pigging123614673pigging
pigmies122610993pigmies
pignus937953pign_us
pignuts1035613pignuts
pigpens1235503pigpens
pigskins1544253pigskins
pinging113419553pinging
pining93726533pi_ning
pinions93413603pi_nions
pinnies93318443pinnies
pinning103417853pinning
pinons86019943pi_nons
pipkins15328183pipkins
pippins10319753pippins
quinins162811293quinins
regains84316583regains
reigning1039883reigning
renins64526453_renins
rennins74013413rennins
ricins83618703ri_cins
rigging103016333rigging
riggings11327133riggings
ringing93521283ringing
rinning83216743rinning
siganids1045303siganids
sighing123311663sighing
sigils73912363sig_ils
signals8359163signals
signees83510803signees
signers84714443signers
signets83311503signets
signify1444853signify
signior835043signior
signiors944923signiors
signors83410913signors
signs65516323sig__ns
simlins9311843simlins
singing93221423singing
sinning83918443sinning
siskins1159583siskins
slinging103312863slinging
tannins72813223tannins
thionins1177923thionins
tiepins939463tiepins
tiffins13327983tiffins
tiglons837343tiglons
tigons74112263tig_ons
tinging93619463tinging
tining74927543ti_ning
tinning83117283tinning
venins93816703_venins
vigias104110893vig_ias
vigils104210193vig_ils
vining104619463vi_ning
violins10311453violins
virgins1137863virgins
wienies102213683wienies
wigans104511703wig_ans
wigeons1136983wigeons
wigging133413833wigging
wiggings14316173wiggings
winging123718713winging
wining103625053wi_ning
winning113516553winning
winnings12327583winnings
withins133511693withins
yogins105114103yog_ins
zigging193210533zigging
zinging183513943zinging
zinnias1635863zinnias

Search took 7 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273555.79623124.1
3Display Results3553550.1262817.5
 (SQL Overall)1786913556.07829399.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.