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

160 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
concoct1031290(None) 
concocts1138631concocts
conceit113218072conceit
concent114422512concent
concept133314442concept
concert113325222concert
concocted1346762concocted
concocter1247622concocter
concoctor1246322concoctor
concord12510342concord
conduct121411592conduct
confect143614272confect
connect113515742connect
consort91319902consort
contact1144020682contact
contort91422342contort
convect143114482convect
convict143410982convict
bonnock1545203bonnock
boycott1457313boycott
cannot83616773canno_t
coact96130583co__act
cocci82812673co_c_ci
coccic8298943coccic_
coccoid11299283coccoid
coccous1039003coccous
coco87330603co_co__
cocoa98517883co_co_a
cocoas104915743co_coas
cocomat13413623co_comat
coconut11511473co_conut
cocoon10312263co_coon
cocos95624693co_co_s
cocotte1138603co_cotte
coenact11311803coenact
coerect11913353coerect
cohort1110720263co_hort
cohost115217213co_host
coinfect15276843coinfect
coldcock1642773coldcock
collect113314593collect
comfort143611693comfort
compact153712213compact
comport133616843comport
compost134515353compost
concave1439373concave
conceal113313013conceal
concede12310093concede
conceits122813613conceits
concents122516603concents
concepti14328273concepti
concepts143110303concepts
concern113011963concern
concerti122912603concerti
concerto123311613concerto
concerts123016063concerts
conch124620073con__ch
concha134213283conc_ha
conchae143911643conchae
conchal144211583conchal
conchas144013313conchas
conches144019813conches
conchie143312683conchie
concho134414263conc_ho
conchoid1688043conchoid
conchos144313963conchos
conchs134714903conc_hs
conchy163710223conc_hy
concise11314473concise
concocters1346753concocters
concocting1448413concocting
concoction1348233concoction
concoctive1646803concoctive
concoctors1346403concoctors
concordat1446353concordat
concords1358593concords
concours1239473concours
concrete12411083concrete
concur10411103conc_ur
concurs11311473concurs
concuss1138063concuss
condo85322593condo__
condoes104319203condoes
condole102914953condole
condom114215363condo_m
condoms124214083condoms
condone102616293condone
condor94616973condo_r
condors104018573condors
condos94322333condo_s
conduce12139233conduce
conducts13118713conducts
conduit10713083conduit
confects153110873confects
confit113316403con_fit
conflict1547753conflict
confocal1546303confocal
conform14310453conform
confront13411603confront
congest104618773congest
congo85623133congo__
congoes103617303congoes
congos94219883congo_s
congou94313243congo_u
congous103615083congous
conic95329793con_ic_
conics103920593con_ics
conjoin1638203conjoin
conjoint17410373conjoint
conjunct1945483conjunct
connects123010563connects
connote9311613connote
conodont11411153conodont
conoid9818883con_oid
consent93723113consent
consist9316033consist
consol82614113conso_l
console92715983console
consols92914073consols
consorts101512343consorts
consult92513633consult
contacts123215213contacts
content94326153content
contest93523233contest
context163913433context
conto76027173conto__
contorts101112643contorts
contos84923233conto_s
contour939973contour
contract122915633contract
convects153410993convects
convent123919413convent
convert123721473convert
convicts15337713convicts
convoke16207173convoke
convoy14348543convo_y
convoys15267023convoys
cooch124916833co__och
coocoo1069693cooco_o
cookout13410153cookout
coopt95929853co__opt
coot67860383co__o_t
coplot10518273coplo_t
copout10418783co_pout
corncob1345663cornco_b
corncobs1444723corncobs
correct11513983correct
coxcomb2243293coxcomb
decoct11313783_decoct
gorcock1643653gorcock
monocot11412013monocot
noncola948293noncola
noncom1039683nonco_m
noncoms1139203noncoms
noncore9411953noncore
nonfact1248893nonfact
oncet74626543_onc_et
rococo1036813ro_coco
topcoat1179313topcoat
uncock1438563_uncock

Search took 7 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.1401276364.3
2DLD Change Limit1340271606.30021274.1
3Display Results1601600.0463478.3
 (SQL Overall)1786911606.48627550.3
 
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.