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

151 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
commodes153909(None) 
commode1438121commode_
commoves1736961commoves
commies133718452comm_ies
commixes2177352commixes
commodores1743972commodores
commoner142710632commoner
commoners15339782commoners
commonest1549252commonest
commons13311042commo_ns
commove1635962commove_
commoved1844762commoved
communes143411242communes
commutes143011892commutes
composes145017112composes
compotes144716512compotes
comrades13149772comrades
corrodes111310332corrodes
cosmoses1239702cosmoses
hommoses1538152hommoses
incommodes1753132incommodes
alamodes1148023alamodes
cammies134016483camm_ies
cathodes1439393cathodes
cestodes1138203cestodes
chamades16138653chamades
cladodes1245323cladodes
cockades1738433cockades
codes86247293c___odes
coelomes1239293coelomes
coembodies1742963coembodies
cojones163512103co_jones
collides113214473collides
colludes11279223colludes
colones96124433co_lones
comade114415323co_made_
comakes154413643co_makes
comates114123643co_mates
combes125321733co_m_bes
combines142814623combines
combos125316613combo__s
comedies13311843comedies
comedones1446933comedones
comedos12329073co_medos
comes97246993co_m__es
comforts15347323comforts
comities12317793comities
commanded17136503commanded
commander16127403commander
commanders17146683commanders
commandoes17255263commandoes
commandos16245963commandos
commands15318823commands
commas124814573comm__as
commences17139583commences
commended17137013commended
commender16167923commender
commenders17137143commenders
commends15308463commends
comments142913883comments
commerces17147233commerces
commie124215523comm_ie_
commits133812383comm_its
commixed2264743commixed
commodifies2153143commodifies
commodify2252553commodify
commodious1753433commodious
commodities1845493commodities
commodity1944393commodity
commodore1644203commodore
common12310803commo__n
commonages1745913commonages
commonly1744963commonly
commonness1644363commonness
commune13329363commune_
communed15338213communed
communer14349303communer
communers15338413communers
commute134310443commute_
commuted15288983commuted
commuter143010153commuter
commuters15378913commuters
comose105016843co_mose_
comous10816503co_mo_us
compadres16266413compadres
compares143816433compares
comperes143217973comperes
competes144117243competes
compiles14311983compiles
complies14314523complies
compone136517193compone_
comports143411983comports
compos124818803compo__s
compose135716663compose_
composed154612063composed
composer145012953composer
composers153910623composers
composts144210913composts
compote135616463compote_
computes143914553computes
comrade12139213comrade_
comtes106222813co_m_tes
concedes13311063concedes
condoes104319203condo_es
condoles113015803condoles
condones112817393condones
condores113315643condores
confides14310573confides
congoes103617303congo_es
conioses10313313conioses
connotes10311453connotes
consoles103216153consoles
convokes17247703convokes
cooees85621893co__oees
coombes133810663coom_bes
cormous11312353cormo_us
corodies11313693co_rodies
corrades111211263corrades
corrode101310573corrode_
corroded12147513corroded
corrodies1247903corrodies
cosmids1237633cosmid_s
cosmos10311753cosmo__s
couvades1435613couvades
cowhides1736013cowhides
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
coyotes12410703co_yotes
crunodes1144973crunodes
custodes1136653custodes
discommodes19123393discommodes
dolmades1245463dolmades
forbodes14217103forbodes
gummoses1344743gummoses
hommocks2143993hommocks
hommos13128503hommo__s
hormones13311163hormones
immodest1344543_immodest
incommode1652793incommode_
incommoded1852593incommoded
lummoxes1942553lummoxes
modes85537413___modes
mommies103912273momm_ies
osmoles9138363_osmoles
osmoses9138123_osmoses
outmodes11208963outmodes
pomades123711733po_mades
pommies133712843pomm_ies
someones1039063someones
tomcods1234873tomcod_s
tommies113812983tomm_ies

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621517.15620425.1
3Display Results1511510.0632396.8
 (SQL Overall)1786911517.64223382.8
 
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.