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

185 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
locular93895(None) 
jocular1637301jocular
lobular936661lobular
ocular8610131_ocular
bilocular1363682bilocular
copular113810602copular
facular122810442facular
globular1143382globular
lacunar9136292lacunar
ligular8348532ligular
loculate101011402loculate
locule83412032locul_e
loculed10317652loculed
locules92812602locules
loculi8288252locul_i
loculus9296972loculus
lunular736012lunular
macular113011942macular
modular1087362modular
morular978222morular
nodular876702nodular
oculars948362_oculars
oscular937932oscular
ovular946832_ovular
popular11319562popular
secular92211532secular
zonular1656492zonular
acicular12218663acicular
alular6311353_alular
angular838533angular
annular737693annular
anovular1144163anovular
avicular13237273avicular
bacula103112673bacula_
bilobular1392413bilobular
binocular1394603binocular
biovular1343603biovular
bolar75123473bo__lar
calycular1643483calycular
canular9310323canular
circular1247903circular
cochlear1543593cochlear
collar83816173co_llar
consular1038813consular
copula102812043copula_
copulae112810613copulae
copulas113811563copulas
coruler9311713coruler
cougar958783co_ugar
cupular11317623cupular
dollar74110983do_llar
doula65717773do_ula_
doulas75114993do_ulas
escolar946053escolar
fabular12288693fabular
facula112912233facula_
faculae123210353faculae
fecula113310053fecula_
feculae12339203feculae
fibular12267973fibular
focuser12155783focuser
foulard11257283fo_ulard
fouler93614903fo_uler
furcular1345703furcular
globulars1242453globulars
gular6314833__gular
hamular1236973hamular
inocula947263inocula_
insular7138703insular
jocularly2173303jocularly
jugular1534513jugular
lacuna8118123lacuna_
lacunae9116803lacunae
lacunal9136553lacunal
lacunars10114733lacunars
lacunary13114153lacunary
lacunas9138173lacunas
ligula7359673ligula_
ligulae8308753ligulae
ligulas8329173ligulas
lingular9407503lingular
lobar7313013lo__bar
lobularly1462693lobularly
lobulate1078833lobulate
lobule82910063lobul_e
lobules92510813lobules
loca65527683loc__a_
local74820273loc__al
locale83915653local_e
locales93715093locales
locally12179723locally
locals83714503local_s
locater93113603locater
locator93110423locator
lochan1139093loc_han
lochia1158313lochia_
lochial1257083lochial
locker124019423loc_ker
lockjaw2341823lockjaw
lockram1544913lockram
loculated1288313loculated
locum94812173locu__m
locums10478303locu_ms
locus74819993locu__s
locust85312343locu_st
locusta9326533locusta
locustae10274713locustae
locustal10325223locustal
locusts9277933locusts
locutory1344273locutory
loller63315283lo_ller
loquat1558283loqu_at
louder74414603lo_uder
louma76213633lo_uma_
loumas84812333lo_umas
lour45430683lo_u__r
louver94110393lo_uver
loyaler1035083loyaler
lunar57017313l__unar
lunula636173lunula_
lunulae735613lunulae
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
modulars1165833modulars
molar75223093mo__lar
molecular1344003molecular
monocular1345813monocular
morula8710473morula_
morulae958963morulae
morulas959713morulas
muscular1246243muscular
mutular936643mutular
nebular956483nebular
ocellar936533_ocellar
ocularly1374643_ocularly
oculi72010793_ocul_i
oculus8178393_oculus
oracular1047533oracular
oscula837293oscula_
ovulary1344913_ovulary
pabular11259473pabular
papular11299763papular
peculiar1245453peculiar
piacular1246573piacular
pilular938203pilular
planular1044753planular
plumular1243303plumular
polar75623453po__lar
poplar103611113po_plar
poulard10299733po_ulard
radular837833radular
ranular739433ranular
regular838423regular
saccular1246893saccular
scalar83612433_scalar
seculars10219393seculars
simular938673simular
solar55927343so__lar
solunar735283solunar
soucar839323so_ucar
specular12217613specular
spicular12238903spicular
sporular1065223sporular
tabular9279763tabular
tegular836603tegular
titular737523titular
tolar55524113to__lar
torula6610393torula_
torulae758553torulae
torulas759853torulas
tubular9267473tubular
tumular9236543tumular
undular837123undular
ungular836773ungular
unilocular1252383unilocular
uvular955563_uvular
vacuolar1353483vacuolar
vascular1346293vascular
venular1037683venular
vocabular1652163vocabular
volar86917413vo__lar
zonula1537223zonula_
zonulae1645963zonulae
zonulas1637023zonulas

Search took 8 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 Limit1340271857.14318763.4
3Display Results1851850.0762434.2
 (SQL Overall)1786911857.37524229.3
 
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.