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

293 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
concerts12301606(None) 
conceits122813611conceits
concents122516601concents
concepts143110301concepts
concerns122710831concerns
concert113325221concert_
concerti122912601concerti
concerto123311611concerto
concertos132711131concertos
converts133213551converts
cancers114018582cancer_s
coexerts1734882coexerts
conceals123111012conceals
concedes13311052concedes
conceit113218072conceit_
concent114422512concent_
concept133314442concept_
concepti14328272concepti
conceptus15295872conceptus
concern113011962concer_n
concerted14312112concerted
concocts1138632concocts
concords1358592concords
concrete12411082concrete
concretes13411472concretes
concurs11311472concur_s
confects153110872confects
confers124120092confer_s
congers104223232conger_s
congests113510382congests
conkers133721042conker_s
connects123010562connects
conners94023112conner_s
consents102715892consents
consorts101512342consorts
contents104018212contents
contests103413382contests
contexts17378652contexts
contorts101112642contorts
convects153410992convects
convents132614602convents
convert123721472convert_
coverts124813812co_verts
bonders104120663bonder_s
boners84825433bon_er_s
bonkers134015303bonker_s
bonnets94812803bonne_ts
bouncers12309353bouncer_s
cancels114113313cance_ls
cancer104220923cancer__
cancered132411553cancered
cancerous1367533cancerous
caners84629203can_er_s
cankers134418753canker_s
canners93822663canner_s
canoers94318373canoer_s
canters94827733canter_s
censers94313903censer_s
centers94420603center_s
chancers154313493chancer_s
cherts115617233c__herts
ciceros1158583c_iceros
cinders104617763cinder_s
cloners94514823clon_er_s
coachers154312303coacher_s
coacts105314333coac__ts
coagents1138453coagents
coalers94419353coaler_s
coaters93525793coater_s
coaxers164311083coaxer_s
cobbers134114753cobber_s
cockers153618333cocker_s
codders114114453codder_s
coders95426983co_der_s
codgers115113933codger_s
coercers1237653coercer_s
coerects1258543coerects
coexert16312363coexert_
coffers154112693coffer_s
coffrets1645363coffrets
coheres122917693co_heres
cohorts123411103co_horts
coilers93619903coiler_s
coiners93620753coiner_s
coinfects16344573coinfects
coinfers13349503coinfer_s
coinheres1447633coinheres
cointers103616413cointer_s
coinvents1445663coinvents
collects12279783collects
collets93517903colle_ts
colters93522443colter_s
combers134516623comber_s
comers105328083co_mer_s
comets105823583co_me_ts
comforts15347323comforts
comments142913883comments
comparts144210833comparts
comperes143217973comperes
comports143411983comports
concaves1538903concaves
conceal113313013conce_al
concede12310093conce_de
conceded1438283conceded
conceder1338733conceder
conceders1437953conceders
conceited14310423conceited
conceive1539233conceive
conceives1639233conceives
concenter13312213concenter
concenters14410583concenters
concerned1438643concerned
concertina14410613concertina
concertinas15107553concertinas
concerting15313893concerting
concertino14910843concertino
concertinos15158123concertinos
concertize23169353concertize
concertizes24158583concertizes
conchas144013313conc_has
conches144019813conc_hes
conchies153214853conchies
conchos144313963conc_hos
conchs134714903conc__hs
concierge1444243concierge
concierges1544543concierges
concoct10312903concoct_
concord12510343concor_d
concordats1544193concordats
concours1239473concours
concreted1439413concreted
concretism1655453concretism
concretist1448193concretist
concur10411103concur__
concuss1138063conc_uss
condemns1336293condemns
condores113315643condores
condors104018573condor_s
conducers14136563conducer_s
conducts13118713conducts
conduits111210063conduits
cones76457423con_e__s
coneys115218423con_e_ys
confect143614273confect_
confer114018683confer__
conferee13613723conferee
conferees14610623conferees
conferva1644433conferva
confervas1744823confervas
confess12399903confe_ss
confetti1345993confetti
confetto1346253confetto
confirms1536303confirms
confits122811423con_fits
conforms1538873conforms
confreres1448033confreres
congeals11309853congeals
congees103517923conge_es
conger95024273conger__
congeries12316403congeries
conges94928173conge__s
congest104618773congest_
congrats11311433congrats
congress1138073congress
conies84338593conie__s
conifers133611703conifer_s
conjures17119913conjures
conker124721553conker__
connect113515743connect_
conner84423963conner__
conquers1938223conquer_s
conquests2045363conquests
consent93723113consent_
conserve1339923conserve
conserves14311193conserves
consists10310593consists
consort91319903consort_
consults10219983consults
contacts123215213contacts
contemns1237403contemns
contempts1545063contempts
contends112810573contends
content94326153content_
contes84432913conte__s
contest93523233contest_
context163913433context_
contort91422343contort_
contras93015623con_tras
convect143114483convect_
convenes132916913convenes
convent123919413convent_
converge1437383converge
converges1538373converges
converse13310263converse
converses14311163converses
converso1336423converso
conversos1446893conversos
converted15311563converted
converter14311013converter
converters1539633converters
convertor1448783convertor
convertors1549133convertors
convexes20278273convexes
conveys15308223conve_ys
convicts15337713convicts
cooers84324563co_oer_s
cookers134619463cooker_s
coolers93522493cooler_s
coopers114019483cooper_s
cooters94525723cooter_s
copers104629843co_per_s
copiers114215963copier_s
copperas14308573copperas
coppers133519753copper_s
copters113621283copter_s
coquets18399893coque_ts
corders104520883corder_s
corers85231073co_rer_s
corkers134118853corker_s
corners94723313corner_s
cornets94820573corne_ts
corrects1259573corrects
corsets94819803corse_ts
corvets124715023corve_ts
cosets85824403co_se_ts
coshers123618183cosher_s
cossets95014283cosse_ts
costers94128333coster_s
cotters94323443cotter_s
couchers153513863coucher_s
counters103320193counter_s
courts84216173co__urts
couters93827303couter_s
covers114627963co_ver_s
covert114925503co_vert_
covets114819643co_ve_ts
cowers114625533co_wer_s
cowherbs1833543cowherbs
cowherds1735423cowherds
culverts13295323culverts
cunners93913473cunner_s
dancers103413093dancer_s
disconcerts1655233disconcerts
docents102810803do_cents
dogcarts1243883dogcarts
donnert82815533donnert_
fencers123810623fencer_s
forcers124215713forcer_s
goners74420173gon_er_s
honers94324973hon_er_s
honkers143315233honker_s
incents92414533_incents
incepts11238283_incepts
incests92711383_incests
inerts64517023_in_erts
inserts74013993_inserts
inverts103211953_inverts
lancers93616643lancer_s
lancets93411163lance_ts
loners64225813lon_er_s
longers84819543longer_s
mincers113714853mincer_s
mongers104217273monger_s
monteros1039453monteros
nerts55924983__n_erts
nonarts7311303non_arts
nonces84418833nonce__s
nonets64118703non_e_ts
obverts1235403_obverts
oncet74626543_once_t_
onsets64013543_onse_ts
oxcarts1634313_oxcarts
pincers113916503pincer_s
ponces104720843ponce__s
ponders103618843ponder_s
pouncers12349203pouncer_s
preconcerts17154503preconcerts
reconverts1545723reconverts
sconces113811453sconce__s
soccers1138393soccer_s
sonders83820713sonder_s
sonnets74211993sonne_ts
toners64128003ton_er_s
tongers84116013tonger_s
tonlets73212503tonle_ts
tonners73816403tonner_s
unconcerns1452723unconcerns
voicers12348993voicer_s
wincers123415363wincer_s
wonders113315993wonder_s
wonners104312813wonner_s
yonkers14379823yonker_s
zoners155115993zon_er_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.1561145455.1
2DLD Change Limit1461622937.34619896.8
3Display Results2932930.1062764.2
 (SQL Overall)1786912937.60823487.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.