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

127 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
mobcap144411(None) 
mobcaps1543461mobcaps
bobcat12411252bobcat
hubcap1553992hubcap
madcap1336332madcap
midcap1336472midcap
mudcap1335132mudcap
toecap1037322toecap
bap76455843__b_ap
becap114315053_becap
bobcats1335993bobcats
boxcar1734753boxcar
cap76758983___cap
cobia94117513cobia_
cobias104014993cobias
cobra95214403cobra_
cobras104014193cobras
coca88030643co_ca_
cocas95926573co_cas
coccal9310223coccal
dobla84913643dobla_
doblas93812293doblas
dobra85013103dobra_
dobras94811913dobras
dognap1035343dognap
focal104917673fo_cal
gelcap1136213gelcap
goban84414073gob_an
hubcaps1643543hubcaps
icecap1245223icecap
lobar7313013lob_ar
loca65527683lo_ca_
local74820273lo_cal
macaw12311763m_acaw
madcaps1435243madcaps
map77255123m___ap
mayhap1635233mayhap
mecca1139933mecca_
meccas1239493meccas
mescal104113483mescal
mezcal19367853mezcal
mica86428253m_ica_
micas96823053m_icas
mishap1338863mishap
moa57249183mo__a_
moan65832023mo__an
moas65545343mo__as
moat66352033mo__at
mob78651923mob___
mobbed137112243mobbed
mobber123613463mobber
mobile103613543mobile
mobled113213183mobled
mobocrat1445703mobocrat
mobs85737373mob__s
moc77845083mo_c__
mocha1249923mo_cha
mochas13310663mochas
mock126429443mo_c_k
mocks135023823mo_cks
mockup1634073mockup
mocs85834903mo_c_s
modal85919243mo_dal
modica11310063modica_
moira71012023moira_
moirai886913moirai
mola66035633mo_la_
molal75120343mo_lal
molar75223093mo_lar
molas75132093mo_las
mollah11319453mollah
momma85111053momma_
mommas94110653mommas
monad85519473mo_nad
monas74732153mo_nas
monocarp14136113monocarp
mooch125313613mooc_h
moola75117033moola_
moolah11409193moolah
moolas83615593moolas
mop76950823mo___p
mora66641273mo_ra_
morae75831193mo_rae
moral75533433mo_ral
moras76438783mo_ras
moray105423793mo_ray
morceau1145573morceau
morgan9311373morgan
mortal84616853mortal
mortar83812043mortar
moshav1446053moshav
mouch124715803mouc_h
moxa136917743mo_xa_
moxas145014393mo_xas
mudcaps1444103mudcaps
mudcat11311203mudcat
musca9311763musca_
muscae10410673muscae
muscat10314653muscat
oba57531553_ob_a_
obas65730933_ob_as
obeah1038993_obeah
obia67923113_obia_
obias76116863_obias
oca56731733_o_ca_
ocas66729633_o_cas
orca65522773_orca_
orcas75918623_orcas
recap95718023_recap
redcap1158493redcap
rootcap1143973rootcap
skycap1742913skycap
snowcap1442823snowcap
soap65831133so__ap
soba64927923sob_a_
sobas74424253sob_as
soca66330053so_ca_
socas74026183so_cas
soucar839323soucar
sowcar1135863sowcar
toecaps1135553toecaps
tomcat101013453tomcat
toucan838193toucan
uncap9312283_uncap
vocab12409973vo_cab
vocal104715643vo_cal
webcam1545543webcam

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.373479064.3
2DLD Change Limit1127161275.15621861.1
3Display Results1271270.0333848.5
 (SQL Overall)1786911275.56232127.1
 
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.