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 “mucosal” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

72 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
mucosal1115584(None) 
mucosa10166271mucosa_
mucosae11155311mucosae
mucosas11146681mucosas
mucoidal1344792mucoidal
mucose10149312mucos_e
accusal11136003accusal
anconal939423anconal
auroral7310473auroral
buccal1248243buc_cal
bucksaw1844373bucksaw
bursal84414823bu_rsal
coal66939253__co_al
comal95125133__comal
copal95621783__copal
coral76033453__coral
costal85419513__costal
coxal146116673__coxal
deposal1037153deposal
ducal84816423duc__al
ductal938993duc_tal
exposal1645313exposal
fucoidal1443783fucoidal
fucose11167683fucos_e
fucoses12148303fucoses
humoral1237973humoral
incisal947373incisal
jucos144111713jucos__
mayoral1237693mayoral
medusal1035183medusal
mensal84615663m_ensal
mimosa1036363mimosa_
mimosas1136753mimosas
missal84314903m_issal
modal85919243m__odal
molal75120343m__olal
moral75533433m__oral
mucks134622643mucks__
mucoid1139783muco_id
mucoids1237423mucoids
mucor94011943muco__r
mucors104410853muco_rs
mucosity1544983mucosity
mucous104411653muco_us
mucus94015743mucus__
mucuses11148513mucuses
mughal1236273mu_ghal
mural75225113mu__ral
musical1139553musical
mussel83412903mu_ssel
mutual838503mu_tual
mycoses1437733mycoses
mycosis1437763mycosis
neurosal845833neurosal
nuchal11218873nuc_hal
nucleal946693nucleal
recoal84117973reco_al
recusal968673recusal
reposal939113reposal
rugosa734563rugosa_
rugosas844973rugosas
seconal9310073seconal
serosal7311153serosal
subcostal1344563subcostal
submucosal1661523submucosal
suboral92011993suboral
suboval12216723suboval
sudoral8148543sudoral
supposal1244913supposal
tumoral938133tumoral
tussal6288323tu_ssal
umbonal1144383umbonal

Search took 7 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.406440125.6
2DLD Change Limit134027725.72023431.3
3Display Results72720.0135538.5
 (SQL Overall)178691726.13929107.5
 
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.