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

272 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
coppra1230683(None) 
coppras13327831coppras
copra98115461co_pra
cobra95214402co_bra
contra83314702contra
coper95336092coper_
copers104629842copers
copped135221252copped
copper124321892copper
copperah17304902copperah
copperas14308572copperas
coppers133519752coppers
coppery16409392coppery
coprah133710602co_prah
copras103517152co_pras
copula102812042copula
corpora1139352corpora
cowpea1337642cowpea
cuppa11398522cupp_a
koppa13397292kopp_a
opera7313572_opera
poppa8409892popp_a
bopped134413403bopped
bopper123813833bopper
boppers133911923boppers
bora66141633bo__ra
camera10313693camera
caper94831623caper_
capers105428143capers
capita102913773capita
caporal11410943caporal
capped134721853capped
capper124421983capper
cappers134419403cappers
centra84113883centra
cesura838763cesura
chakra15437533chakra
cholera12409093cholera
chopped174511003chopped
chopper163611893chopper
choppers174110463choppers
choppy18376293chopp_y
chuppa1543973chuppa
clopped143611523clopped
coala77521123co_ala
coappear1442893coappear
coapt96131533coap_t
coapts104614013coapts
cobia94117513co_bia
cobras104014193co_bras
coca88030643co__ca
cocoa98517883co_coa
coda77029343co__da
codeia94112193codeia
coder86134223coder_
coders95426983coders
cohere112716993cohere
cohort1110720263cohort
coir66327243co_ir_
coirs75221053co_irs
cola66541393co__la
collar83816173collar
color76123743color_
colors86622373colors
colure8314163colure
colza165112983co_lza
coma87134853co__ma
comer95832693comer_
comers105328083comers
comma114514793co_mma
comp106731253comp__
compare135814993compare
compart134016003compart
compas125817063compas
comped135919873comped
compel124412893compel
compere134616623compere
comply152810383comply
compo115318573comp_o
comport133616843comport
compos124818803compos
comps115526053comp_s
compt116328223comp_t
compts125216653compts
concha134213283concha
conga85419873co_nga
contras93015623contras
cooer74831013cooer_
cooers84324563cooers
coop87238653coop__
cooped114821603cooped
cooper104221123cooper
coopers114019483coopers
coopery143910273coopery
coops96229643coop_s
coopt95929853coop_t
coopts105814583coopts
cop711162373co_p__
copaiba1344483copaiba
copal95621783co_pal
copalm125010813copalm
copals105018943copals
copay126516313co_pay
copays134911273copays
cope86847383co_p_e
copeck1636943copeck
coped105036843co_ped
copen94826433co_pen
copens106119963copens
copepod1444853copepod
copes97747103co_pes
copied114618563copied
copier103722893copier
copiers114215963copiers
copies104130303copies
coping113927663coping
coplot10518273coplot
copout10418783copout
copperahs18323893copperahs
coppered153410543coppered
coppice1537483coppice
copping143918593copping
coprahs14338153co_prahs
cops86751373co_p_s
copse95623923co_pse
copses104922473copses
copter109822013copter
copters113621283copters
copulae112810613copulae
copular113810603copular
copulas113811563copulas
copy116229803co_p_y
copycat1647593copycat
copyread1643783copyread
cor59960943co__r_
coral76033453co__ral
cord76740923co__rd
core67263113co__re
corer75538873corer_
corers85231073corers
corf95941483co__rf
coria75828323co_ria
cork106635693co__rk
corm85735373co__rm
corn69945813co__rn
cornea84018923cornea
cornua85411903cornua
corona83817403corona
corporal1248513corporal
corps95927043corp_s
corpse104013403corpse
corpus106015293corpus
corral83616253co_rral
cors66656443co__rs
cory96941513co__ry
coryza2074583coryza
costa75523733co_sta
costar85518613costar
cotta75818573co_tta
cottar84613813cottar
cougar958783cougar
coup86729793coup__
coupe96023483coup_e
couped115019313couped
coupes105022523coupes
couple104415963couple
coupon102810993coupon
coups95522473coup_s
court75532773co_urt
covary1438743covary
cover105430773cover_
covers114627963covers
covert114925503covert
coward12411673coward
cower104531773cower_
cowers114625533cowers
cowpat13312033cowpat
cowpeas1437273cowpeas
cowpie133511513cowpie
cowpox2035003cowpox
cowry135512483co_wry
coxa136922963co__xa
coyer105222843coyer_
coypou13268403coypou
coypu12349873coyp_u
coypus13389303coypus
cropped143812063cropped
cropper133312963cropper
croppers143311483croppers
croppie13278793croppie
crura7312583c_rura
culpa93610963culp_a
cupola10317693cupola
cuppas12458593cuppas
cupped134413983cupped
cupper124313863cupper
cuppers133712213cuppers
cuppy144710383cupp_y
cupula10328433cupula
curara83712203curara
dobra85013103do_bra
dopa77220903do_p_a
doper86128393doper_
dopers95522483dopers
doura66518663do_ura
fopped144012673fopped
foppery17385623foppery
fora75937393fo__ra
hoopla1147633hoopla
hoper105829143hoper_
hopers114222973hopers
hopped144318113hopped
hopper134218483hopper
hoppers143115143hoppers
hopple132910483hopple
hoppy154912353hopp_y
hora76136563ho__ra
kappa13469743kapp_a
koppas14407603koppas
koppie14277883koppie
kora86431553ko__ra
loper75129233loper_
lopers84424143lopers
lopped114218623lopped
lopper103717203lopper
loppers113014103loppers
loppy125911663lopp_y
moira71012023mo_ira
moper94925923moper_
mopers104220373mopers
mopery135210973mopery
mopped134114323mopped
mopper126215003mopper
moppers133412463moppers
moppet126915093moppet
mora66641273mo__ra
nappa98511863napp_a
nonpar8168993nonpar
okra86413573_o_kra
operas8312453_operas
ora37250833_o__ra
orra46120723_o_rra
para65242173__para
popery134511703popery
poplar103611113poplar
poppas93710713poppas
popped104117813popped
popper93615963popper
poppers103414863poppers
poppet92717323poppet
popple92710983popple
poppy114813193popp_y
roper75431913roper_
ropers84325903ropers
ropery114313873ropery
rostra6310933rostra
scopula1154993scopula
sopor74016493sopor_
sopors85215203sopors
sopped114819903sopped
soppy125113523sopp_y
sora45746913so__ra
supra73614253_supra
tephra1136483tephra
toper75231023toper_
topers85025323topers
topped114617723topped
topper103817603topper
toppers113914603toppers
topple104411323topple
tora47545993to__ra
womera11137593womera

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162725.70319764.3
3Display Results2722720.0763578.9
 (SQL Overall)1786912725.91930189.4
 
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.