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

118 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
mudcap133513(None) 
madcap1336331madcap
midcap1336471midcap
mudcaps1444101mudcaps
mudcat11311201mudcat
hubcap1553992hubcap
madcaps1435242madcaps
mobcap1444112mobcap
mudcats1236222mudcats
mudflap1542182mudflap
mudra83912432mudra_
mudras94212252mudras
musca9311762musca_
muscae10410672muscae
muscat10314652muscat
redcap1158492redcap
uncap9312282_uncap
audad71511383aud_ad
audial7312993audial
becap114315053_becap
bluecap1343113bluecap
buccal1248243buccal
burlap1098353burlap
cap76758983___cap
dap66652453__d_ap
ducal84816423du_cal
ducat86225903du_cat
gelcap1136213gelcap
giddap1143413giddap
hubcaps1643543hubcaps
icecap1245223icecap
judas134911883jud_as
kidnap1334193kidnap
macaw12311763m_acaw
madam10316223mad_am
madman113712383madman
madras94316423madras
map77255113m___ap
mayhap1635233mayhap
mecca1139933mecca_
meccas1239493meccas
medal86221323med_al
media84721713media_
mediad104313713mediad
mediae94217413mediae
medial93819863medial
median94117543median
medias93620783medias
medical12312513medical
medigap1374623medigap
medlar93010463medlar
mescal104113483mescal
mezcal19367853mezcal
mica86428243m_ica_
micas96823053m_icas
midday13327503midday
midway15327153midway
mishap1338863mishap
mobcaps1543463mobcaps
modal85919233mod_al
modica11310063modica_
much115224033mu_c_h
mucho125013443mu_cho
mucid104115253mu_cid
mucin93116823mu_cin
muck125727853mu_c_k
mucks134622643mu_cks
mucky165015253mu_cky
mucor94011943mu_cor
mucro94513723mu_cro
mucus94015743mu_cus
mud67336863mud___
mudbug1243253mudbug
mudcapped1941373mudcapped
mudded114511383mudded
mudder104413493mudder
muddle103414633muddle
muddly13418603muddly
muddy123812233mud_dy
mudflaps1641803mudflaps
mudflat1364883mudflat
mudhen1236883mudhen
mudlark1463913mudlark
mudpack1843593mudpack
muds75530653mud__s
muggar10316443muggar
mughal1236263mughal
mulch124012973mulc_h
mulct93820083mulc_t
mulcts10298713mulcts
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
mump105425723mu__mp
munch124917103munc_h
mura65633293mu_ra_
mural75225103mu_ral
muras75329563mu_ras
murra74519083murra_
murras84916003murras
muscats1138933muscats
muscid11219833muscid
muscle10310973muscle
muscly1337453muscly
musical1139553musical
mutch125016173mutc_h
mutual838503mutual
recap95718023_recap
redcaps1247073redcaps
skycap1742913skycap
succah1336643succah
sulcal8311273sulcal
toecap1037323toecap
uncaps1039813_uncaps
yuca95716723yu_ca_
yucas106013913yu_cas
yucca12467443yucca_
yuccas13426553yuccas

Search took 6 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 Filter1786911127160.1431249587.4
2DLD Change Limit1127161185.01322484.7
3Display Results1181180.0462565.2
 (SQL Overall)1786911185.20234350.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.