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

195 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
coppice153748(None) 
coppiced1734821coppiced
coppices1638241coppices
caprice1349682caprice
codpiece1544062codpiece
compile13312442compile
complice1639332complice
copping143918592copping
coprince1447092coprince
cornice11612932cornice
cowpie133511512cowpi_e
croppie13278792croppi_e
hospice14117052hospice
koppie14277872koppi_e
auspice1136523auspice
bodice11711423bo_dice
bopping143512033bopping
buppie12288733buppi_e
caddice13327733caddice
capping143819673capping
capric12411793capric_
caprices1439893caprices
caprine11314233caprine
capsize2037623capsize
captive1438973captive
chalice14311043chalice
chappie16298653chappi_e
chippie16297693chippi_e
choice132010523c_hoice
chopine143512263chopine
choppier17286643choppier
choppily2044133choppily
chopping183710263chopping
cilice103213353c_ilice
cioppino1443343cioppino
clopping153511083clopping
cocaine111315173cocaine
coccic8298943coccic_
codeine103815033codeine
codices12512583co_dices
codpieces1643803codpieces
codrive1337643codrive
coerce10310403co_erce
coesite9713623coesite
cognise1059683cognise
cognize1957683cognize
colic95726173co_lic_
colics104219903co_lics
collide103214783collide
collie83621993colli_e
combine133014723combine
comic114721813co_mic_
comics124015563co_mics
commie124215523commi_e
compact153712213compact
compare135814993compare
compere134616623compere
compete134716553compete
compiled1537813compiled
compiler1438373compiler
compiles14311983compiles
comping143518593comping
complices1739253complices
compline14313553compline
compone136517193compone
compose135716663compose
compote135616463compote
comprise14310813comprise
comprize2368733comprize
compute134513653compute
concise11314473concise
conduce12139223conduce
confide13310203confide
confine12315583confine
conic95329793co_nic_
conics103920593co_nics
coniine9316803coniine
conine84528553co_nine
connive1238993connive
conspire1257873conspire
convict143410983convict
convince1547363convince
cookie123716043cooki_e
coolie83821603cooli_e
cooping123918933cooping
cootie84223073cooti_e
copaiba1344483copaiba
cope86847383co_p__e
copeck1636943co_peck
copied114618563co_pied
copier103722893co_pier
copies104130303co_pies
copihue1444143copihue
coping113927663co_ping
copped135221253copp_ed
copper124321893copp_er
coppered153410543coppered
coppers133519753coppers
coppery16409393coppery
coppicing1845403coppicing
coppra12306833copp_ra
coppras13327833coppras
coprinces1547483coprinces
copse95623923co_p_se
copulae112810613copulae
copying153411983copying
copyist1439053copyist
corbie103618203corbi_e
cordite10315253cordite
corniced1368593corniced
cornices12713283cornices
corniche1575923corniche
cornicle1258783cornicle
corpse104013403corp_se
corrie83621213corri_e
cortices12615003cortices
corvine122113643corvine
cosie74728263co_si_e
cosine83823513co_sine
cosmic12410343cosmic_
costive12312843costive
coupe96023483coup__e
couping124317023couping
couple104415963coup_le
cowhide1636133cowhide
cowlick1835263cowlick
cowpies143314283cowpies
cowpoke1835103cowpoke
cowrie113814273cowri_e
cowrite123612683cowrite
cozie163519123co_zi_e
crappie13298983crappi_e
crevice1436153crevice
croppies143111133croppies
cropping153210883cropping
cuplike1537213cuplike
cuppier1368323cuppier
cupping144312383cupping
cupric1249113cupric_
cuprite1159683cuprite
dormice1237133dormice
fopping153511133fopping
foppish1735103foppish
hippie132811243hippi_e
hoplite12311073hoplite
hoppier143110703hoppier
hopping154115273hopping
hopple132910483hopp_le
hospices1587633hospices
koppies153210013koppies
loppier11369723loppier
lopping123815223lopping
mopping143411473mopping
mortice11711493mortice
nappie104112263nappi_e
noplace1137393noplace
notice8313443no_tice
novice1138433no_vice
office1435693_office
ophite11410563_ophite
opine77422463_o_pine
oppose1039193_oppose
optic93715183_optic_
optics102810183_optics
optime1079343_optime
orpine83914483_orpine
orrice81410163_orrice
pice84641093___pice
police102918563po_lice
poppied11388983poppied
poppies102816193poppies
popping113715413popping
popple92710983popp_le
popsicle1443653popsicle
popsie103013053popsi_e
potpie103412423potpi_e
price93725413__price
reprice113212833reprice
sopite84917713so_pite
soppier112711583soppier
sopping123917203sopping
spice95528813__spice
splice104915103_splice
toepiece1243273toepiece
topic95721503to_pic_
topics104714583to_pics
topkick1443143topkick
topline92313183topline
topping123514623topping
topple104411323topp_le
topside1037733topside
uppile10178503_uppile
voice104915323vo__ice
yippie13277843yippi_e
yuppie13297133yuppi_e

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340271958.12616493.6
3Display Results1951950.0633095.2
 (SQL Overall)1786911958.32921454.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.