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

110 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
mucosas1114667(None) 
mucosa10166271mucosa_
mucosae11155311mucosae
mucosal11155841mucosal
fucoses12148302fucoses
mimosas1136752mimosas
mucoids1237412mucoids
mucors104410842muco_rs
mucose10149312mucos_e
mucous104411652muco_us
mucuses11148512mucuses
mycoses1437722mycoses
mycosis1437752mycosis
rugosas844972rugosas
accosts11107993accosts
aftosas10147143aftosas
aucubas1145173aucubas
auroras7311703auroras
buckras1537343buckras
bucksaw1844373bucksaw
bucksaws1943853bucksaws
bursas85318273bu_rsas
casas75327843__casas
cocas95926573__cocas
cocoas104915743coco_as
codas84724243__codas
colas75436773__colas
comas95833003__comas
coses76949493__coses
coss66143493__cos_s
costs77231143__costs
cupolas11277753cupolas
fuchsias16113533fuchsias
fucoids1335663fucoids
fucose11167683fucos_e
fucous11399863fuco_us
fucuses12158353fucuses
glucoses1145333glucoses
jucos144111713juco__s
judokas1992453judokas
leucomas1244453leucomas
macons104017243maco_ns
maculas113114013maculas
masas75630413m__asas
massas85116463m_assas
meccas1239493mec_cas
medusas1036213medusas
meioses9310833meioses
meiosis939023meiosis
mensas85115853m_ensas
mesas76823203m__esas
micas96823053mic__as
mimosa1036363mimosa_
mioses84318853m_ioses
miosis83615163m_iosis
mitoses9312183mitoses
mitosis939633mitosis
moas65545343m__o_as
mochas13310653moc_has
molas75132093m__olas
monas74732153m__onas
moolas83615593m_oolas
moras76438763m__oras
mosks116117003m__osks
moss67641033m__os_s
mosts76028543m__osts
moxas145014393m__oxas
muches134718993muc_hes
mucins102712513muc_ins
muckers153612793muckers
muckles153413253muckles
mucks134622643muc__ks
muclucs1343683muclucs
mucoid1139773muco_id
mucoidal1344783mucoidal
mucor94011943muco__r
mucosity1544983mucosity
mucrones1237603mucrones
mucus94015743muc__us
mudras94212253mu_dras
muletas937383muletas
mullas84215933mu_llas
muons75816173mu_o_ns
muras75329563mu__ras
murras84916003mu_rras
murrhas12286163murrhas
muses75134303mu__ses
musks116119643mu__sks
muss64933763mu__s_s
musses84624783mu_sses
musts75527443mu__sts
mutases92012043mutases
mutisms11338453mutisms
mutons84314363muto_ns
myomas1338293m_yomas
myoses114013843m_yoses
myosis114012553m_yosis
mysosts1234543mysosts
myxomas2153903myxomas
quotas15339433qu_otas
rugolas836373rugolas
rugosa734563rugosa_
samosas939293samosas
serosas7312663serosas
submucosas1671313submucosas
sucroses1039933sucroses
sycoses1249133sycoses
sycosis1238803sycosis
yucas106013913yuc__as
yuccas13426553yuc_cas

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.1601116818.8
2DLD Change Limit1340271108.20016344.8
3Display Results1101100.0502200.0
 (SQL Overall)1786911108.41021247.4
 
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.