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

153 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
loculus929697(None) 
locules92812601locules
oculus8178391_oculus
flocculus1652222flocculus
limulus935082limulus
lobules92510812lobules
locales93715092locales
locals83714502local_s
locular938952locular
locule83412032locul_e
loculed10317652loculed
loculi8288252locul_i
locums10478302locu_ms
locus74819992loc__us
locusts9277932locusts
lulus54315162l__ulus
modulus10245332modulus
nocuous946582nocuous
aculeus937513_aculeus
annulus7426613annulus
apiculus1245413apiculus
baculum1345703baculum
baculums1443723baculums
bolus79125543bo__lus
boucles113113003boucles
boules84925973bo_ules
calculus1255333calculus
calyculus1642243calyculus
coccous1039003coccous
coccus979283coc_cus
cockles153414643cockles
copulas113811563copulas
coulis84018763co_ulis
culls75425813__culls
culms95314193__culms
cults75022553__cults
cultus85110733__cultus
cumulus1135453cumulus
doulas75114993do_ulas
famulus1235043famulus
floccules1642853floccules
floccus1443653floc_cus
focus105815883foc__us
focuses12159653focuses
fouls87221433fo_ul_s
fumulus1234443fumulus
globules1135413globules
hamulus1235323hamulus
hocus104715203hoc__us
hocuses121710423hocuses
incubus1144743incubus
inoculum1243443inoculum
inoculums1342683inoculums
jocular1637303jocular
joules134116823jo_ules
lacunas9138173lacunas
lacunes9159623lacunes
lazulis1634903lazulis
ligulas8329173ligulas
ligules82210923ligules
lobular936663lobular
lobule82910063lobul_e
lobulose1044033lobulose
local74820273local__
locale83915653local_e
localise101511853localise
localism121310013localism
localist101613963localist
locally12179723locally
locates93218813locates
lochans1248833lochans
lochs106715513loc__hs
lockers133516923lockers
lockets134612203lockets
locknut1345253locknut
locknuts1443683locknuts
lockout1359333lockout
lockouts1445493lockouts
locks115126923loc__ks
lockup1434763loc_kup
lockups1534243lockups
locoes85516583loc_oes
locos75822603loc__os
loculate101011403loculate
locum94812173loc__um
locust85312343locu_st
locusta9326533locusta
lodicules1243363lodicules
lolls512121733lo__lls
loquats1645273loquats
losels64714583losel_s
lotus55718063lo__tus
lotuses74011253lotuses
loughs105014773lo_ughs
louies64525103lo_uies
louis57322323lo_u_is
loumas84812333lo_umas
loupes84918053lo_upes
loups75319623lo_u_ps
lours55125293lo_u_rs
louses66230283lo_uses
louts56330273lo_u_ts
luaus54514903l__uaus
lulls54119653l__ulls
lulu44122883l__ulu_
lunules738953lunules
lupus74512523l__upus
lusus54813873l__usus
maculas113114023maculas
macules114015133macules
modules102511003modules
moguls948553mogul_s
morulas959713morulas
moulds94910993mo_ulds
moults84713703mo_ults
noctules1036583noctules
nodules8269703nodules
nodulous944733nodulous
nonplus936183nonplus
obelus8348403_obelus
obolus8378813_obolus
occults1135123occults
ocellus935983_ocellus
ocular8610133_ocular
oculars948363_oculars
oculi72010793_ocul_i
oculist9310883_oculist
oscules938123oscules
osculum1143833osculum
ovules938223_ovules
piculs103511753picul_s
poilus82210573po_ilus
populous1245953populous
poults84613483po_ults
regulus836523regulus
sacculus1244813sacculus
sculks123610263_sculks
sculls84613883_sculls
sculps104611753_sculps
socles8418453soc_les
solus54726983so__lus
souls55127363so_ul_s
sulus54821883__sulus
tolus55024483to__lus
torulas759853torulas
tumulus935033tumulus
ulus45622563___ulus
vacuous1237023vacuous
vocals113811583vocal_s
volvulus1441933volvulus
zocalos1835393zocalos
zonulas1637023zonulas
zonules1647793zonules

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.423422437.4
2DLD Change Limit1340271536.95319276.1
3Display Results1531530.0463326.1
 (SQL Overall)1786911537.42224075.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.