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

258 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
concerns12271083(None) 
concern113011961concern_
concerts123016061concerts
cancers114018582cancer_s
conceals123111032conceals
concedes13311062concedes
conceits122813612conceits
concent114422512conce_nt
concents122516602concents
concepts143110302concepts
concerned1438642concerned
concert113325222concer_t
concerti122912602concerti
concerto123311612concerto
concertos132711132concertos
concords1358602concords
concurs11311472concur_s
condemns1336292condemns
confers124120092confer_s
congers104223232conger_s
conkers133721042conker_s
conners94023112conner_s
contemns1237402contemns
converts133213552converts
unconcerns1452722unconcerns
bonders104120663bonder_s
boners84825433bon_er_s
bonkers134015303bonker_s
bouncers12309353bouncer_s
cancans11311873canc_ans
cancels114113313cance_ls
cancer104220923cancer__
cancered132411553cancered
cancerous1367533cancerous
caners84629203can_er_s
cankers134418753canker_s
canners93822663canner_s
canoers94318373canoer_s
canteens1038573canteens
canters94827733canter_s
caserns94711223c_aserns
caverns124510253c_averns
censers94313903censer_s
centers94420603center_s
chancers154313493chancer_s
ciceros1158593c_iceros
cinders104617763cinder_s
cinerins10414103cin_erins
cisterns10369583cisterns
citherns13338873citherns
citterns10318123citterns
cloners94514823clon_er_s
coachers154312303coacher_s
coalers94419353coaler_s
coaters93525793coater_s
coaxers164311083coaxer_s
cobbers134114753cobber_s
cocains111313923co_cains
cochins141413103co_chins
cockers153618333cocker_s
cocoons11310563co_coons
codders114114453codder_s
codeins103715483co_deins
codens94821013co_de_ns
coders95426983co_der_s
codgers115113933codger_s
coercers1237653coercer_s
coexerts1734883coexerts
coffers154112693coffer_s
coheres122917693co_heres
coilers93619903coiler_s
coiners93620753coiner_s
coinfers13349503coinfer_s
coinheres1447633coinheres
cointers103616423cointer_s
colleens1036843colleens
colters93522443colter_s
combers134516623comber_s
comers105328083co_mer_s
comperes143217973comperes
concaves1538913concaves
conceal113313023conce_al
concede12310103conce_de
conceded1438293conceded
conceder1338743conceder
conceders1437953conceders
conceding1559343conceding
conceit113218073conce_it
conceive1539233conceive
conceives1639233conceives
concept133314443conce_pt
concepti14328273concepti
conceptus15295873conceptus
concerning1548903concerning
concerted14312113concerted
concertina14410633concertina
concertinas15107563concertinas
concerting15313893concerting
concertino14910843concertino
concertinos15158123concertinos
conchas144013313conc_has
conches144019813conc_hes
conchies153214853conchies
conchos144313963conc_hos
conchs134714903conc__hs
concierge1444253concierge
concierges1544553concierges
concocts1138633concocts
concord12510343concor_d
concours1239473concours
concrete12411083concrete
concretes13411473concretes
concur10411103concur__
concuss1138063conc_uss
condemn1237113condemn_
condense1179613conde_nse
condores113315643condores
condors104018573condor_s
conducers14136563conducer_s
cones76457423con_e__s
coneys115218423con_e_ys
confects153110873confects
confer114018683confer__
conferee13613733conferee
conferees14610623conferees
conferva1644433conferva
confervas1744823confervas
confess12399903confe_ss
confirms1536303confirms
conforms1538873conforms
confreres1448033confreres
congeals11309863congeals
congees103517923conge_es
conger95024273conger__
congeries12316403congeries
conges94928173conge__s
congests113510383congests
congress1138073congress
conies84338593conie__s
conifers133611703conifer_s
conins84327233con__ins
conjoins1738133conjoins
conjures17119913conjures
conker124721553conker__
connects123010563connects
conner84423963conner__
conns75024233con___ns
conquers1938223conquer_s
consent93723113conse_nt
consents102715893consents
conserve1339933conserve
conserves14311193conserves
consigns1137533consigns
consorts101512343consorts
contains10316533contains
contemn1137803contemn_
contend103511893conte_nd
contends112810573contends
content94326153conte_nt
contents104018213contents
contes84432913conte__s
contests103413383contests
contexts17378653contexts
contorts101112643contorts
contras93015623con_tras
convects153410993convects
convene123314323conve_ne
convenes132916913convenes
convent123919413conve_nt
convents132614603convents
converge1437393converge
converges1538383converges
converse13310263converse
converses14311163converses
converso1336423converso
conversos1446893conversos
convert123721473conver_t
convexes20278273convexes
conveys15308223conve_ys
cooers84324563co_oer_s
cookers134619463cooker_s
coolers93522493cooler_s
cooncans1246273coonc_ans
coopers114019483cooper_s
cooters94525733cooter_s
copens106119963co_pe_ns
copers104629843co_per_s
copiers114215963copier_s
copperas14308573copperas
coppers133519753copper_s
copters113621283copter_s
corders104520883corder_s
corers85231073co_rer_s
corkers134118853corker_s
corners94723313corner_s
corns76034763co___rns
coshers123618183cosher_s
costers94128343coster_s
cothurns1344523cothurns
cotters94323453cotter_s
couchers153513863coucher_s
counters103320193counter_s
couters93827303couter_s
covens114919263co_ve_ns
covers114627963co_ver_s
coverts124813813co_verts
cowers114625533co_wer_s
cowherbs1833543cowherbs
cowherds1735423cowherds
cozens176314923co_ze_ns
croceins1238103croceins
cunners93913473cunner_s
dancers103413093dancer_s
decerns10119053_decerns
discerns1138163discerns
fencers123810623fencer_s
forcers124215713forcer_s
goners74420173gon_er_s
governs1136103go_verns
honers94324973hon_er_s
honkers143315233honker_s
interns73116773_interns
lancers93616643lancer_s
lanterns838303lanterns
loners64225813lon_er_s
longerons1045893longerons
longers84819543longer_s
lucerns935753_lucerns
mincers113714853mincer_s
moderns1037963mo_derns
monerans10310353mon_erans
mongers104217273monger_s
monteros1039453monteros
nonces84418833nonce__s
nonconcerns1554493nonconcerns
oceans81211003_o_ceans
orceins937743_orceins
pincers113916503pincer_s
ponces104720843ponce__s
ponders103618843ponder_s
popcorns1444023popcorns
posterns102713723posterns
pouncers12349203pouncer_s
sconces113811453sconce__s
sconcheons1742093sconcheons
secerns987733_secerns
soccers1138393soccer_s
sonders83820713sonder_s
toners64128003ton_er_s
tongers84116013tonger_s
tonners73816403tonner_s
unconcern1343183unconcern_
voicers12348993voicer_s
wincers123415363wincer_s
wonders113315993wonder_s
wonners104312813wonner_s
yonkers14379823yonker_s
zoners155115993zon_er_s

Search took 9 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.420425454.8
2DLD Change Limit1461622587.94018408.3
3Display Results2582580.1102345.5
 (SQL Overall)1786912588.47021096.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.