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

222 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
ligula735967(None) 
ligulae8308751ligulae
ligular8348531ligular
ligulas8329171ligulas
ligule74010831ligule
lingula8428801lingula
cingula10327172cingula
fibula11258052fibula
jugula1434982jugula
laguna7127222laguna
ligulate92510252ligulate
ligules82210922ligules
ligure7279472ligure
likuta1034212likuta
limuli836342limuli
lingua7509912lingu_a
lingual8379082lingual
lingulae9357032lingulae
lingular9407502lingular
lunula636172lunula
sigla64515202sig_la
ungula737602ungula
acicula11228133acicula
alula5317093_alula
angular838533angular
argala74712673argala
arugula843913arugula
bacula103112673bacula
begulf1238903begulf
bigly114814753big_ly
canula8312963canula
cedula977643cedula
cicala10310053cicala
cingular11256973cingular
citola838393citola
coagula1045413coagula
copula102812043copula
cupula10328433cupula
doula65717773_doula
eidola737683eidola
engulf1038883engulf
facula112912233facula
fecula113310053fecula
ferula93011173ferula
fibulae12237013fibulae
fibular12267973fibular
fibulas12228563fibulas
figural1145243figural
figure10258833figure
fila74729133fi__la
fistula1045503fistula
gala55635163__gala
giga66720943gig__a
giggle94313513giggle
giggly12518703giggly
gigolo836533gigolo
gigue71210673gigu_e
gigues8129003gigues
gul45832793__gul_
gulag7310823__gulag
gular6314833__gular
gulf84929423__gulf
gull54828453__gull
gulp75521363__gulp
guls55930853__guls
higgle113811743higgle
highly1636823highly
hila76228353hi__la
hula74923753__hula
iglu510814783_ig_lu
iglus6609933_iglus
iguana735813_iguana
ingulf10310353ingulf
jiggle153811993jiggle
jiggly18378713jiggly
jugular1534513jugular
kibla1139833ki_bla
lacuna8118123lacuna
lagunas8156823lagunas
lagune7158633lagune
laura54116203l_aura
lazuli1535363lazuli
legal65715943legal_
legals73412733legals
legume936913legume
lehua837953lehu_a
liable81415813liable
liana53915893li_ana
libel74116103libel_
libels85112693libels
liblab1035083li_blab
libra74712423li_bra
liefly1266363liefly
lienal63912783lienal
lieu46534363lieu__
lieus56218483lieu_s
ligan67920283lig_an
ligand85011293ligand
ligans76817733ligans
ligase7259913ligase
ligate72519253ligate
liger65024473lig_er
ligers75022043ligers
light94429603lig_ht
lightly14369023lightly
lights104519913lights
lignan75510323lignan
lignin74911193lignin
ligulated11247363ligulated
liguloid1044133liguloid
ligures8269893ligures
likely13328133likely
lilac7311073li__lac
lilo46731563li__lo
lilt46349943li__lt
lily76730183li__ly
lima65734133li__ma
limba95414983li_mba
limina83514503limina
limpa97014463li_mpa
limply133810033limply
limulus935083limulus
lineal65616023lineal
linga66820823li_nga
linguae8398413linguae
linguals9317223linguals
linguica1143483linguica
linguisa944473linguisa
lingulate10368193lingulate
linum7313823linu_m
linums838283linums
lipa68425923li__pa
lipoma1046753lipoma
liquid1637143liquid
liquor1534203liquor
lira46928683li__ra
lisle53916723li_sle
lithia939333lithia
little63312163little
litu47631563litu__
lively123310813lively
lobular936663lobular
lobule82910063lobule
locular938953locular
locule83412033locule
loculi8288253loculi
loggia8457053loggia
logia68116603log_ia
logily1039833logily
louma76213633l_ouma
lull44225763l__ull
lulu44122883l__ulu
luma65527523l__uma
luna46229853l__una
lunulae735613lunulae
lunular736013lunular
lunule638433lunule
macula103013673macula
miaul71612123miaul_
miauls8178713miauls
miggle104012113miggle
mizuna1734303mizuna
mogul8310213mogul_
moguls948563moguls
morula8710473morula
nebula857333nebula
nigella844523nigella
niggle83612823niggle
niggly11418913niggly
oliguria9133573oliguria
oscula837293oscula
papula103011113papula
picul95015363picul_
piculs103511753piculs
pilular938203pilular
pilule8411123pilule
pinnula934913pinnula
planula935773planula
plugola1043013plugola
primula1145713primula
pula65129373__pula
radula749313radula
ranula6311813ranula
regular838423regular
reguli738143reguli
ritual6310623ritual
rugola736293rugola
sigil63515503sigil_
sigils73912363sigils
siglum936563siglum
sigma84513833sig_ma
signa66114703sig_na
signal73711483signal
silicula1065393silicula
simular938673simular
singular9327563singular
spicula11259293spicula
spinula9257903spinula
spirula9257703spirula
tegua6109563tegu_a
tegular836603tegular
titular737523titular
torula6610393torula
ungual738183ungual
ungulae837313ungulae
ungular836773ungular
uvula845153_uvula
vicuna11115903vicuna
viga85622963vig__a
vigia94813273vig_ia
vigil94313003vigil_
vigils104210193vigils
villa85321233vi_lla
vincula1246393vincula
viola85915543vi_ola
virgule1144283virgule
visual938803visual
vizsla1833703vizsla
weigela1143073weigela
wiggle113713013wiggle
wiggly14559683wiggly
zonula1537223zonula

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 Filter1786911127160.440406115.9
2DLD Change Limit1127162225.86019234.8
3Display Results2222220.0762921.1
 (SQL Overall)1786912226.37628025.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.