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

218 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
lunula63617(None) 
lunulae735611lunulae
lunular736011lunular
lunule638431lunule
canula8312962canula
cupula10328432cupula
jugula1434982jugula
ligula7359672ligula
lingula8428792lingula
luna46229852lun__a
lunulate838252lunulate
lunules738952lunules
planula935772planula
ranula6311812ranula
ungula737602_ungula
uvula845152_uvula
zonula1537222zonula
alula5317093_alula
annual64710703annual
annul55813383annul_
annular737693annular
annuli6459053annuli
annuls64711733annuls
arugula843913arugula
aucuba1045493aucuba
auntly95211063auntly
bacula103112673bacula
bluntly1235223bluntly
bulla74620563bu_lla
buna64730723bun__a
bundle94315573bundle
bungle97116113bungle
bunya103810093bun_ya
cannula937433cannula
canola8313623canola
canulae9311183canulae
canular9310323canular
canulas9312853canulas
cedula977643cedula
cingula10327163cingula
copula102812043copula
cumuli1036273cumuli
cuneal8611513cuneal
cupola10317693cupola
cupulae11347853cupulae
cupular11317623cupular
cupule103410723cupule
curule83614123curule
doula65717773_doula
eunuch1154363eunuch
facula112912233facula
fecula113310053fecula
ferula93011173ferula
fibula11258053fibula
frenula1045623frenula
fumuli1135263fumuli
fungal10388733fungal
funkia1336343funkia
furcula1245793furcula
fusuma1134503fusuma
genua64614153genu_a
gunplay1343233gunplay
hula74923753__hula
jugular1534513jugular
jungle144012653jungle
jungly17407693jungly
junta123713673jun_ta
kuna85120703kun__a
lacuna8118123lacuna
laguna7127223laguna
lanely93914483lanely
lankly13439623lankly
lanugo735573lanugo
laura54116203l_aura
lazuli1535363lazuli
lehua837953lehu_a
ligulae8308753ligulae
ligular8348533ligular
ligulas8329163ligulas
ligule74010833ligule
likuta1034213likuta
limuli836343limuli
lineal65616023lineal
linga66820813lin_ga
lingua7509903lingua
lingual8379073lingual
lingulae9357013lingulae
lingular9407483lingular
linum7313823linu_m
linums838283linums
lobular936663lobular
lobule82910063lobule
locular938953locular
locule83412033locule
loculi8288253loculi
lonely92912463lonely
longly10279603longly
louma76213633l_ouma
luau44824163luau__
luaus54514903luau_s
luffa11409023lu_ffa
lull44225763l__ull
lulls54119653lu_lls
lulu44122883l__ulu
lulus54315163lulu_s
luma65527523l__uma
lumina84613543lumina
lunacy1136843lunacy
lunar57017313lun_ar
lunars65012813lunars
lunas55025013lun_as
lunate6316043lunate
lunch104917243lun_ch
lune47140493lun__e
lunes55337773lun_es
lunet56835423lun_et
lunets66914763lunets
lung55732493lun__g
lungan74710213lungan
lunge65323803lun_ge
lunged85418273lunged
lungee75119813lungee
lunger75720413lunger
lunges76123423lunges
lungful1144013lungful_
lungfuls1242773lungfuls
lungi65516053lun_gi
lungis77113023lungis
lungs65223883lun_gs
lungyi10525093lungyi
lunier64617603lunier
lunies64723013lunies
lunk86030723lun__k
lunker104718343lunker
lunks94822453lun_ks
lunt46148843lun__t
lunted74517523lunted
lunts55826903lun_ts
lunulated1036783lunulated
luny77324133lun__y
lupulin945003lupulin
lupus74512523lupu_s
lushly12247343lushly
lustra6358893lustra
lusus54813873lusu_s
lutea54819073lu_tea
luteal64411483luteal
luxury1642543luxury
macula103013673macula
manila84518303manila
manual8313463manual
morula8710473morula
mulla74317113mu_lla
mutual838503mutual
mutular936643mutular
mutule8311423mutule
nala46930393__nala
nebula857333nebula
neurula744373neurula
null45125313__null
nuncle839363nuncle
oscula837293oscula
papula103011113papula
penult8314653penult
pinnula934913pinnula
planulae1044793planulae
planular1044753planular
plugola1043013plugola
plumular1243303plumular
plumule1134303plumule
pula65129373__pula
puna65331653pun__a
pungle94413573pungle
punily11311773punily
punka114515483pun_ka
quinela1635203quinela
radula749313radula
ranular739433ranular
ranulas7311773ranulas
rugola736293rugola
rundle73214233rundle
runkle103611543runkle
spinula9257903spinula
sunna55016063sun_na
sunup7313053sunu_p
sunups837263sunups
synura935983synura
torula6610393torula
tubular9267473tubular
tubule839853tubule
tumular9236543tumular
tumuli835933tumuli
tumult839703tumult
tuna45127843tun__a
tundra736423tundra
tunica8379813tunica
ulna46317323uln__a
uncia75015163_uncia
unclad938913_unclad
uncle7317053_uncle
undular837123_undular
unduly1037823_unduly
ungual738183_ungual
ungulae837313_ungulae
ungular836773_ungular
unlay84613703_un_lay
unruly938083_unruly
usual5310183_usual
uvulae945323_uvulae
uvular955563_uvular
uvulas946523_uvulas
venular1037683venular
venule94411763venule
vincula1246393vincula
zonulae1645963zonulae
zonular1656493zonular
zonulas1637023zonulas
zonule1577483zonule

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.1401276364.3
2DLD Change Limit1127162187.92314226.4
3Display Results2182180.0633460.3
 (SQL Overall)1786912188.12621990.0
 
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.