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

143 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
jocular163730(None) 
locular938951locular
ocular8610131_ocular
copular113810602copular
facular122810442facular
jocularly2173302jocularly
jugular1534512jugular
lobular936662lobular
macular113011942macular
modular1087362modular
morular978222morular
nodular876702nodular
oculars948362_oculars
oscular937932oscular
ovular946832_ovular
popular11319562popular
secular92211532secular
zonular1656492zonular
acicular12218663acicular
alular6311353_alular
angular838533angular
annular737693annular
anovular1144163anovular
avicular13237273avicular
bacula103112673bacula_
bilocular1363683bilocular
binocular1394603binocular
biovular1343603biovular
bolar75123473bo__lar
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
globular1143383globular
gular6314833__gular
hamular1236973hamular
inocula947263inocula_
insular7138703insular
jacamar1844323jacamar
jaculate172311783jaculate
jaguar1435283jagu_ar
jocularity2253683jocularity
jocund1633623jocu_nd
joggler16398833joggler
jostler14288223jostler
joual12311653jo_u_al
jouals1338923jo_uals
joule124918203jo_ul_e
joules134116823jo_ules
jowar155211433jo__war
jugula1434983jugula_
jugulars1643233jugulars
lacunar9136293lacunar
ligular8348533ligular
loculate101011403loculate
locule83412033locul_e
loculed10317653loculed
locules92812603locules
loculi8288253locul_i
loculus9296973loculus
lunular736013lunular
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
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
uvular955563_uvular
vacuolar1353483vacuolar
vascular1346293vascular
venular1037683venular
vocabular1652163vocabular
volar86917413vo__lar
zonula1537223zonula_
zonulae1645963zonulae
zonulas1637023zonulas

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 Filter1786911340270.296603685.8
2DLD Change Limit1340271437.87617017.1
3Display Results1431430.0463108.7
 (SQL Overall)1786911438.21821743.9
 
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.