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

90 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
mobcaps154346(None) 
mobcap1444111mobcap_
bobcats1335992bobcats
hubcaps1643542hubcaps
madcaps1435242madcaps
mudcaps1444102mudcaps
toecaps1135552toecaps
baps86040843__b_aps
becaps123811403_becaps
bobcat12411253bobca_t
boxcars1834773boxcars
caps87147893___caps
cobias104014993cobia_s
cobras104014193cobra_s
cocas95926573co_ca_s
doblas93812293dobla_s
dobras94811913dobra_s
dognaps1134393dognaps
forceps14466983forceps
gelcaps1235203gelcaps
gobans94412043gob_ans
hubcap1553993hubcap_
icecaps1343863icecaps
locals83714503lo_cals
macaws1337023m_acaws
madcap1336333madcap_
maps86141053m___aps
meccas1239493mecca_s
mescals112911573mescals
mezcals20246543mezcals
micas96823053m_ica_s
midcap1336473midcap_
mishaps1438723mishaps
moans74624373mo__ans
moas65545343mo__a_s
moats75827643mo__ats
mobbers133610923mobbers
mobiles112813123mobiles
mobocrats1544253mobocrats
mobs85737373mob___s
mochas13310663mo_chas
mocks135023823mo_c_ks
mockups1733343mockups
mocs85834903mo_c__s
modals93914463mo_dals
molars85517323mo_lars
molas75132093mo_la_s
mollahs12328283mollahs
mommas94110653momma_s
monads94515303mo_nads
monas74732153mo_na_s
monocarps1595643monocarps
mooches143714453mooches
moolahs12347383moolahs
moolas83615593moola_s
mops85940133mo___ps
morals85324643mo_rals
moras76438783mo_ra_s
morass84614503mo_rass
morays114613883mo_rays
morgans10310123morgans
mortals93914013mortals
mortars93411523mortars
mouches143815963mouches
moxas145014403mo_xa_s
mudcap1335133mudcap_
mudcats1236223mudcats
muscats1138933muscats
obas65730933_ob_a_s
obeahs1135863_obeahs
obias76116863_obia_s
ocas66729633_o_ca_s
orcas75918623_orca_s
recaps103615733_recaps
redcaps1247073redcaps
rootcaps1243863rootcaps
skycaps1842703skycaps
snowcaps1542703snowcaps
soaps75120713so__aps
sobas74424253sob_a_s
socas74026183so_ca_s
soucars938423soucars
sowcars1236013sowcars
toecap1037323toecap_
tomcats11127773tomcats
toucans937583toucans
uncaps1039813_uncaps
vocabs13336313vo_cabs
vocals113811583vo_cals
webcams1643073webcams

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.406440125.6
2DLD Change Limit134027907.03319056.9
3Display Results90900.0303000.0
 (SQL Overall)178691907.46923924.4
 
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.