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

226 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
concents12251660(None) 
conceits122813611conceits
concent114422511concent_
concepts143110301concepts
concerts123016061concerts
consents102715891consents
contents104018211contents
convents132614601convents
coagents1138452coagents
coinvents1445662coinvents
comments142913882comments
conceals123111012conceals
concedes13311052concedes
conceit113218072conceit_
concenter13312212concenter
concenters14410582concenters
concept133314442concept_
concepti14328272concepti
conceptus15295872conceptus
concerns122710832concerns
concert113325222concert_
concerti122912602concerti
concerto123311612concerto
concertos132711132concertos
concocts1138632concocts
confects153110872confects
congests113510382congests
connects123010562connects
consent93723112consent_
contends112810572contends
content94326152content_
contests103413382contests
contexts17378652contexts
convects153410992convects
convenes132916912convenes
convent123919412convent_
converts133213552converts
docents102810802do_cents
incents92414532_incents
accents113511233_accents
acescents1345233acescents
ancients1098973_ancients
ascents93812553_ascents
bonnets94812803bonne_ts
cancans11311873cancan_s
cancels114113313cance_ls
cancers114018583cance_rs
candent10417363candent_
cements112714223c_ements
cents74730333___cents
cholents1337623cholents
clients938093c_lients
coacts105314333coac__ts
coagent10313983coagent_
coconuts1246333co_conuts
codens94821013co_den_s
coerects1258543coerects
coexerts1734883coexerts
cogent9321003co_gent_
coinfects16344573coinfects
coinvent1348183coinvent_
collects12279783collects
collets93517903colle_ts
comets105823583co_me_ts
commends15308463commends
comment1310317703comment_
compends15378253compends
concaves1538903concaves
conceal113313013conce_al
concede12310093conce_de
conceded1438283conceded
conceder1338733conceder
conceders1437953conceders
conceited14310423conceited
conceive1539233conceive
conceives1639233conceives
concentric1346133concentric
concern113011963conce_rn
concerned1438643concerned
concerted14312113concerted
conchas144013313conc_has
conches144019813conc_hes
conchies153214853conchies
conchos144313963conc_hos
conchs134714903conc__hs
concoct10312903concoct_
concords1358593concords
concours1239473concours
concrete12411083concrete
concretes13411473concretes
concurrents1554563concurrents
concurs11311473conc_urs
concuss1138063conc_uss
condemns1336293condemns
condense1179613condense
condenses12710133condenses
condiments1548193condiments
condones112817393condones
conducts13118713conducts
conduits111210063conduits
conenose1078593con_enose
cones76457423con_e__s
coneys115218423con_e_ys
confect143614273confect_
confers124120093confe_rs
confess12399903confe_ss
confetti1345993confetti
confetto1346253confetto
confines13315653confines
confits122811423con_fits
confluents1545413confluents
confronts1447063confronts
congeals11309853congeals
congees103517923conge_es
congener112412203congener
congeners122511133congeners
congers104223233conge_rs
conges94928173conge__s
congest104618773congest_
congrats11311433congrats
conies84338593conie__s
coniines10415363coniines
conines93827793con_ines
conins84327233con_in_s
conjuncts2043653conjuncts
conjunto1744653conjunto
conjuntos1844373conjuntos
conkers133721043conke_rs
connect113515743connect_
conners94023113conne_rs
conns75024233con__n_s
conodonts1246063conodonts
conquests2045363conquests
consensus1144923consensus
consented12311943consented
consenter11312493consenter
consenters12410843consenters
consists10310593consists
consorts101512343consorts
constants11410913constants
consults10219983consults
contacts123215213contacts
contemns1237403contemns
contempts1545063contempts
contend103511893conten_d
contented12313043contented
contes84432913conte__s
contest93523233contest_
context163913433context_
continents1249563continents
contorts101112643contorts
convect143114483convect_
convene123314323conven_e
convened143412223convened
convener132913163convener
conveners142911443conveners
convenor13307613convenor
convenors14277633convenors
convented15410753convented
convert123721473convert_
convexes20278273convexes
conveys15308223conve_ys
convicts15337713convicts
coolants1039943coolants
cooncans1246273cooncan_s
coparents1347973coparents
copens106119963co_pen_s
coquets18399893coque_ts
cornets94820573corne_ts
coronets103814363coronets
corrects1259573corrects
corsets94819803corse_ts
corvets124715023corve_ts
cosecants1346533cosecants
cosets85824403co_se_ts
cossets95014283cosse_ts
cotangents1344163cotangents
counts84618273co__unts
courants10310803courants
covens114919263co_ven_s
coverts124813813co_verts
covets114819643co_ve_ts
cozens176314923co_zen_s
crescents1367543crescents
currents1038373currents
descents112511203descents
docent92918683do_cent_
foments122912053fo_ments
fondants1246203fondants
incants92012803_incants
incent83320723_incent_
incepts11238283_incepts
incests92711383_incests
indents83114663_indents
innocents1145313innocents
intents72115703_intents
invents102812053_invents
lancets93411163lance_ts
loments93413473lo_ments
moments113113123mo_ments
monuments1397633monuments
mordents1138813mordents
nocent83217413no_cent_
nonces84418833nonce__s
nonets64118703non_e_ts
nonevents1247483nonevents
oncet74626543_once_t_
onsets64013543_onse_ts
orients7311583_orients
pendents1139413pendents
percents122713373percents
ponces104720843ponce__s
ponent82821593pon_ent_
portents103512823portents
precents123015043precents
rodents8611543ro_dents
scents85317023__scents
sconces113811453sconce__s
solvents1136763solvents
sonants7511233son_ants
sonnets74211993sonne_ts
sorbents10279133sorbents
tangents938713tangents
tonlets73212503tonle_ts
torments10310453torments
torrents838143torrents

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.1561145455.1
2DLD Change Limit1461622267.36019859.0
3Display Results2262260.0932430.1
 (SQL Overall)1786912267.60923484.2
 
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.