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

507 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
limina8351450(None) 
lamina84920441lamina
liminal93810671liminal
liming94021241liming
lumina84613541lumina
vimina11339941vimina
aiming94320842aiming
alumina9510052alumina
gliming113310132gliming
imine75821062_imine
imino74315232_imino
jiminy1836272jiminy
lamia75324322lami_a
laminae93512972laminae
laminal94113632laminal
laminar93810282laminar
laminas93615872laminas
laming94528362laming
latina65621142latina
liana53915892li_ana
liking114319582liking
lima65734132lim__a
liman75921602liman_
limans84816302limans
limba95414982lim_ba
limbing123410422limbing
limen75426032limen_
limens84618032limens
limier83518722limier
limit73126342limi_t
limits82514142limits
limn66527692lim_n_
limnic10418842limnic
limning103710322limning
limns75718392lim_ns
limpa97014462lim_pa
limping124614112limping
linin58025522linin_
lining74526802lining
linins65922142linins
lipin75518892lipin_
lipins85016882lipins
living104318322living
luminal93711002luminal
miming114317262miming
mina65136912__mina
nomina83113682nomina
numina83510842numina
riming93322222riming
rumina83412482rumina
semina8915562semina
simian8811162simian
sliming102913952sliming
timing93619302timing
viminal12288822viminal
aiding84423613aiding
ailing74331013ailing
airing74927503airing
aliment9316703aliment
alimony1236013alimony
alining81917043alining
alumin8513543alumin_
aluminas1048353aluminas
alumine9412693alumine
alumins9512983alumins
alumna857343alum_na
amia66836903_ami_a
amiga85514813_amiga
amin66042253_amin_
amine75835383_amine
amino75425503_amino
amins75534323_amins
ammine10314493ammine
ammino1069883ammino
amnia75918643_amnia
angina7413133angina
arming94719803arming
biding104720793biding
biking135018173biking
bikini12418913bikini
bima86723833bim__a
biting95321823biting
blaming123515693blaming
bluming123511283bluming
bulimia1145043bulimi_a
camisa103114323camisa
carina84325323carina
chiming153311833chiming
china105022483_china
cilia73016763cili_a
citing94220183citing
claiming13279303claiming
climbing15205983climbing
clivia1177233clivi_a
coming114225453coming
criminal1248303criminal
crimine112413473crimine
crimini11258883crimini
criminy14268453criminy
cumin94616973cumin_
cumins103314933cumins
damiana1046563damiana
deliming12310373deliming
diamin9312523diamin_
diamine10311983diamine
diamins10312213diamins
dicing105718763dicing
dieing84018653dieing
diking124320243diking
dimity12310473dimity
dimming13339593dimming
dining84525133dining
divine103514463divine
diving113717953diving
domine92918253domine
doming104218393doming
domino92611493domino
eliding93414343eliding
eliminate1147733eliminate
encina8310443encina
ermine8416923ermine
famine114318193famine
faming124922973faming
farina94618233farina
ficin103516723ficin_
ficins113513983ficins
fifing134212343fifing
filing103823763filing
filming133210353filming
fining104223213fining
firing104021723firing
firming132811223firming
fixing174813783fixing
flaming134216443flaming
fliting113514613fliting
fluming133512793fluming
fuming124013293fuming
gamin84423003gamin_
gamine94620153gamine
gaming104622043gaming
gamins94420043gamins
geminal10109903geminal
germina1038493germina
gibing103712353gibing
gieing83614853gieing
gimping133710763gimping
giving114313883giving
gliding103911843gliding
griming113612493griming
hemin103620933hemin_
hemins113417563hemins
hiding114319333hiding
hieing104216623hieing
hiking143617103hiking
hiring104421603hiring
hiving134115523hiving
homing123718383homing
hominy144511483hominy
icing86017753_icing
ilia46026823_ili_a
imid76122293_imi_d
imide85716893_imide
imido85812243_imido
imids86015143_imids
imines84918353_imines
imping114315353_imping
inia45024703_ini_a
iring66025423_iring
ixia115713213_ixi_a
jarina134014063jarina
jibing16379623jibing
jimminy2133373jimminy
jiving173711603jiving
kimono12105413kimono
kina85631993__kina
kinin94917323kinin_
kinins104014583kinins
kiting114117093kiting
labia75219013labi_a
lacing94626233lacing
lacuna8118123lacuna
lading84227123lading
ladino73615123ladino
laguna7127223laguna
lain46146283l_ain_
lairing83715343lairing
laking115027043laking
lama66635293lam__a
lambda1146113lambda
lambing123412413lambing
lament85024943lament
lamiae84817453lamiae
lamias85020613lamias
laminals10339303laminals
laminary13337253laminary
laminate103014633laminate
laminin939973laminin
lamming123014583lamming
lamping123116003lamping
lapin75222923lapin_
lapins84520683lapins
larine63927043larine
lasing74727983lasing
latinas74416463latinas
latino64120473latino
laving104623573laving
lawine93316463lawine
lawing104625283lawing
layin84720333layin_
laying104525703laying
layins93817653layins
lazing164821473lazing
leman75622603leman_
lemans85316393lemans
lemma94811033lem_ma
lemming12269393lemming
lemon75618183lemon_
lemons84415053lemons
lemony11419553lemony
lempira1144193lempira
levin84816413levin_
levins94514653levins
lexica1536103lexica
liaise6310693liaise
lianas63713383li_anas
liane54720663li_ane
liang64914413li_ang
libido935753libido
libra74712423li_bra
licit74327683lici_t
licking144118283licking
lidding103611433lidding
lien45339803li_en_
lienal63912783li_enal
liens56525503li_ens
lierne638023lierne
lifting113313273lifting
ligan67920283ligan_
ligand85011293ligand
ligans76817733ligans
lignan75510323li_gnan
lignin74911193lignin
lignins84010493lignins
ligula7359673ligula
liken911818843liken_
likens105613703likens
likings12539413likings
likuta1034213likuta
lilied73913213lilied
lilies63021413lilies
lilting83515383lilting
limacine1246003limacine
limas75627633lim_as
limb85429383lim__b
limbas105313203limbas
limbed114513183limbed
limber104316793limber
limbi96513813lim_bi
limbic12528743limbic
limbier11349113limbier
limbo95614813lim_bo
limbos104712143limbos
limbs96118943lim_bs
limbus105710383limbus
limby125714073lim_by
lime66244933lim__e
limed85426803lim_ed
limes75636503lim_es
limey104721043lim_ey
limeys11429273limeys
limiest93716103limiest
liminess10510643liminess
limitary1344933limitary
limited102310233limited
limiter92710853limiter
limites92915453limites
limiting1138813limiting
limmer104314793limmer
limned94811473limned
limner84112873limner
limo65529733lim__o
limos75320813lim_os
limp88432493lim__p
limpas105513083limpas
limped114817123limped
limper104117853limper
limpet103518633limpet
limpid11389753limpid
limpkin1534223limpkin_
limpkins1644233limpkins
limply133810033limply
limps95522673lim_ps
limpsy13516843limpsy
limuli836343limuli
limy95727713lim__y
lin37967373l__in_
linac7315413l__inac
line46965573l__ine
linen55728723linen_
linens64818393linens
lineny94011443lineny
ling57447963l__ing
linga66820823li_nga
lingua7509913lingua
linier64423793linier
linings84313073linings
link86943443l__ink
linking123818253linking
linn46034593l__inn
linns56123333li_nns
lino46343373l__ino
lins47059053l__ins
lint416266233l__int
linting83820983linting
liny78141323l__iny
lion46334443li_on_
lions55923213li_ons
lipa68425923l__ipa
lipid85916173lipi_d
lipide93511063lipide
lipids94310923lipids
lipoma1046753lipoma
lipping123016073lipping
lira46928683l__ira
liri45128253liri__
lisping103412753lisping
listing84020593listing
litany939053litany
lithia939333lithia
liven85021733liven_
livens94314893livens
livid96714423livi_d
livier97514593livier
livings11408923livings
lixivia1743053lixivia
loaming103613733loaming
logia68116603logi_a
login66025003login_
logins77820643logins
loiding93313403loiding
loin46838723l_oin_
loins56728423l_oins
lomein8410203lomein_
lomeins969473lomeins
loment84021473loment
lomenta92710133lomenta
looing73621043looing
looming102814853looming
loping93921413loping
lorica8310443lorica
losing74022873losing
loving104416723loving
lowing104623273lowing
loxing143615273loxing
lubing94114043lubing
luging83915293luging
luma65527523lum__a
lumen75220903lumen_
lumenal9307273lumenal
lumens85013973lumens
luminary13336653luminary
lumping123314643lumping
luna46229853l__una
lupin75215843lupin_
lupine84013533lupine
lupins84514463lupins
luring73820753luring
luting75221753luting
lying95717453l_ying
lysin84512783lysin_
lysine94210553lysine
lysing104710443lysing
lysins94610953lysins
maiming122912723maiming
mana65341943__mana
marina84623413marina
medina94114093medina
mica86428253__mica
miking134218463miking
milia72719573mili_a
mimic111414323mimi_c
mimical1339233mimical
mimics1289363mimics
mimosa1036363mimosa
minae75627723__minae
minas75434113__minas
mind75434373__mind
mine67256163__mine
mini65634553__mini
minima105512653minima
mining94225453mining
mink106636523__mink
mint66758053__mint
minx137723343__minx
mirin75023153mirin_
miring93723803miring
mirins83918903mirins
mixing164713943mixing
mizuna1734303mizuna
myna95815293__myna
naming93917893naming
niding83217983niding
nimming12358143nimming
nixing143311493nixing
nominal92712373nominal
oidia6314953oidi_a
oiling74925313oiling
olivine1038843olivine
patina86022193patina
pembina1345213pembina
pieing93917653pieing
piing85218833pi_ing
piking133719643piking
piling95025593piling
pima85428653pim__a
pimping143812123pimping
pina65842633__pina
pining93726533pining
pinna75320183pi_nna
piping114017453piping
pirana8713263pirana
piscina1177043piscina
platina94413643platina
pluming123412043pluming
primine113214823primine
priming123417373priming
quinina16278143quinina
ramona8412413ramona
regina75317143regina
remind94819793remind
remint85329973remint
retina65023383retina
ricin74620213ricin_
ricing94822763ricing
ricins83618703ricins
riding84325963riding
riling74227973riling
rimier83916273rimier
rimming123411073rimming
riping93821613riping
rising74025883rising
riving104521423riving
ruminal9289993ruminal
saimin8313663saimin_
saimins9312113saimins
salina64221123salina
seminal91213403seminal
seminar979753seminar
siding83822133siding
sienna647193sienna
signa66114703si_gna
silica8311243silica
sima64730783sim__a
simians959203simians
similar937853similar
simile83115633simile
simitar936733simitar
simlin8311733simlin_
simlins9311843simlins
simony1137903simony
siping94220633siping
siring75128313siring
siting74126623siting
sizing163616443sizing
slicing103514643slicing
sliding93114553sliding
slimier93212013slimier
slimily1247713slimily
slimming13288093slimming
sliping103314413sliping
stamina9310793stamina
taming94023433taming
tegmina1035243tegmina
tibia7312403tibi_a
tiding83520093tiding
tieing73518763tieing
tiling73426553tiling
timid84815733timi_d
timings10279303timings
timpana11226133timpana
tining74927543tining
tiring74023093tiring
titian62512663titian
vagina102710933vagina
velamina1345663velamina
vicinal12268543vicinal
vicing124014243vicing
vicuna11115903vicuna
vigia94813273vigi_a
viking143414613viking
vimen104114753vimen_
vina76331803__vina
vining104619463vining
vising103915873vising
vomica1336383vomica
wifing133513393wifing
wiling103024293wiling
wimmin1336153wimmin_
wimping153911013wimping
wining103625053wining
wiping123916713wiping
wiring104521023wiring
wising103318223wising
witing103522823witing
wiving133316603wiving
zamia165115213zami_a
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 Limit1127165078.56313163.1
3Display Results5075070.1533313.7
 (SQL Overall)1786915078.85920170.6
 
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.