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

153 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
concours123947(None) 
concourse1345801concourse
concurs11311471conc_urs
contours1039651contours
candours11408642candours
coccous1039002coccou_s
colours95913442co_lours
concocts1138632concocts
concord12510342conco_rd
concords1358592concords
concourses1445352concourses
concur10411102conc_ur_
concuss1138062conc_uss
condors104018572condo_rs
congous103615082congou_s
contour939972contour_
honours10339372hon_ours
rancours1076712rancours
bescours1245093bescours
cancers114018583canc_ers
candors104216763cando_rs
candour104210243candour_
canoers94318373can_oers
cantors94620753canto_rs
censors93611843censo_rs
centaurs1035733centaurs
cincture1245583cincture
cinctures1346063cinctures
clamours1255993clamours
clangours12263123clangours
clours85215093c__lours
coachers154312303coachers
coactors1239473coactors
coanchors1645733coanchors
coccoids12176793coccoids
coccus979283co_ccu_s
cockers153618333co_ckers
cockups1735223co_ckups
cocoas104915743co_co_as
coconuts1246333co_conuts
cocoons11310563co_coons
cocos95624693co_co__s
colors86622373co_lo_rs
colour85915093co_lour_
comous10816503co_mou_s
conatus9310463conatu_s
concaves1538913concaves
conceals123111013conceals
conceders1437953conceders
concedes13311063concedes
conceits122813613conceits
concents122516603concents
concepts143110303concepts
concern113011963conc_ern
concerns122710833concerns
concert113325223conc_ert
concerts123016063concerts
conchas144013313conc_has
conches144019813conc_hes
conchies153214853conchies
conchoids1766273conchoids
conchos144313963conc_hos
conchs134714903conc__hs
conclude1344673conclude
concluders1543493concluders
concludes1445143concludes
concoct10312903conco_ct
concocters1346753concocters
concoctors1346403concoctors
condoes104319203condo_es
condolers122710573condolers
condoles113015803condoles
condoms124214083condo_ms
condoners122811513condoners
condones112817393condones
condor94616973condo_r_
condores113315643condores
condos94322333condo__s
confers124120093con_fers
conform14310463confo_rm
conforms1538873conforms
confound1445903confound
confounds1544323confounds
congers104223233con_gers
congius103210073congiu_s
congoes103617303congo_es
congos94219883congo__s
congou94313243congou__
conifers133611703conifers
conioses10313313conioses
coniosis1048133coniosis
coniums11311863con_iums
conjoins1738133conjoins
conjure16109073con_jure
conjures17119913con_jures
conkers133721043con_kers
conners94023113con_ners
connotes10311453connotes
conoids10813883con_oids
conquers1938223conquers
conscious1347593consciou_s
consolers112510923consolers
consoles103216153consoles
consols92914073conso_ls
consort91319903conso_rt
consorts101512343consorts
consuls92412313con_suls
contort91422343conto_rt
contorts101112643contorts
contos84923233conto__s
contoured1237303contoured
conus76726533con__u_s
convokers18246103convokers
convokes17247703convokes
convoys15267023convo_ys
cooers84324563co__oers
cookouts1446003cookouts
copious11311963copiou_s
copouts11311083co_pouts
cormous11312353cormou_s
corncobs1444723cornco_bs
corneous10310033corneou_s
couchers153513863couchers
couloirs1045993couloirs
couscous1246683couscou_s
coxcombs2342353coxcombs
coypous14248813coypou_s
dolours8438823do_lours
donors75115793don_o_rs
douceurs1142793douceurs
downcourt1553543downcourt
downpours1542533downpours
ecotours1044463eco_tours
honors94816793hon_o_rs
honour94710863hon_our_
incurs83012283_inc_urs
inpours936423_inpours
noncolas1048613noncolas
noncolors1147033noncolors
noncoms1139203nonco_ms
nonconcurs1454563nonconcurs
noncore9411953nonco_re
occurs10136553_o_ccurs
odours7418253_o_dours
pandours11317993pandours
rancors9811373ranco_rs
rancour987133rancour_
recontours1243463recontours
santours837183santours
scours84913593__scours
succours1244593succours
tenours72610073ten_ours
zincous1837053zincou_s

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.436409841.7
2DLD Change Limit1461621537.28320068.9
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.77922970.9
 
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.