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

266 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
copious1131196(None) 
captious122810572captious
carious93320282carious
coccous1039002coccous
coitus8511892co_itus
comous10816502co_mous
congous103615082congous
copiers114215962copiers
copies104130302copi_es
copihue1444142copihue
copihues1543992copihues
copilots1255752copilots
copings124111842copings
copiously1646742copiously
coplots11511592coplots
copout10418782cop_out
copouts11311082cop_outs
cormous11312352cormous
coypous14248812coypous
cuprous1149742cuprous
curious93813562curious
folious103710732folious
impious1137062impious
noxious1446562noxious
odious749932_odious
pious74621272__pious
acoelous1047023acoelous
adipous1037183adipous
anxious1437283anxious
apodous1037403apodous
bilious9310933bilious
boubous1138693boubous
cachous14312583cachous
callous93516603callous
camions113916133camions
campions143511293campions
capacious1546603capacious
capias10318353capi_as
capitols12247333capitols
capizes20410373capizes
capons104119503cap_ons
capos94826073cap_o_s
captions123813223captions
captors113914983captors
caribous1258823caribous
caseous9312513caseous
cations94524143cations
cautious103110233cautious
cerous85821203c_erous
chiaus113611313c_hiaus
chirus114615693c_hirus
chophouse1945293chophouse
chopines152711733chopines
chopins142312243chopi_ns
chorions13310663chorions
chylous15107273chylous
chymous1775703chymous
cions75222853c__ions
cirrous93111063cirrous
citrous93112993citrous
cobias104014993cobi_as
coccus979283co_ccus
cocoas104915743co_coas
cocoons11310563cocoons
cocos95624693co_co_s
codices12512583codices
codons96119463co_dons
coeloms1139063coeloms
cogitos1037613cogitos
cogons96818113co_gons
cohogs125810273co_hogs
cohos105921853co_ho_s
coifs105718703co_i_fs
coigns94410063co_igns
coils75030083co_i_ls
coins75834553co_i_ns
coirs75221053co_i_rs
coitions10312853coitions
cojoins1638993cojoins
coleus86818273co_leus
colics104219903coli_cs
colies84837053coli_es
colins85229043coli_ns
colitis92617353colitis
collops112611753collops
colobus11389373colobus
cologs96517353co_logs
colons86028683co_lons
colonus94413443colonus
colors86622373co_lors
colour85915093co_lour
colours95913443co_lours
colpitis1247503colpitis
combos125316613combo_s
comics124015563comi_cs
comings124013533comings
commons13311043commons
compiles14311983compiles
complots1438163complots
compos124818803compo_s
conatus9310463conatus
concours1239473concours
condoes104319203condoes
condoms124214083condoms
condors104018573condors
condos94322333condo_s
congius103210073congius
congoes103617303congoes
congos94219883congo_s
congou94313243congou_
conics103920593coni_cs
conies84338593coni_es
conines93827793conines
conins84327233coni_ns
conioses10313313conioses
coniosis1048133coniosis
conium10415313coni_um
coniums11311863coniums
conoids10813883conoids
conscious1347593conscious
consols92914073consols
contos84923233conto_s
contour939973contour
contours1039653contours
conus76726533co__nus
convoys15267023convoys
coofs105924713co__ofs
cookout13410153cookout
cookouts1446003cookouts
cooks115429143co__oks
cools75632633co__ols
coons76737283co__ons
coops96229643co__ops
cooptions13107763cooptions
coos67456493co__o_s
coots75636843co__ots
copaibas1443563copaibas
copalms13367543copalms
copals105018943cop_als
copays134911273cop_ays
copecks1745873copecks
copens106119963cop_ens
copepods1544713copepods
copers104629843cop_ers
copes97747103cop__es
copied114618563copi_ed
copier103722893copi_er
copilot11811263copilot
coping113927663copi_ng
coplot10518273coplo_t
coppers133519753coppers
coppices1638243coppices
coppras13327833coppras
coprahs14338153coprahs
copras103517153cop_ras
cops86751373cop___s
copses104922473cop_ses
copters113621283copters
copulas113811563copulas
copyboys2042663copyboys
copyists1545993copyists
cordons104415763cordons
corium10315723cori_um
corneous10310033corneous
cornus84816563co_rnus
corpus106015293co_rpus
cosies84932153cosi_es
cosigns1047513cosigns
cosines94122673cosines
cosmos10311753cosmo_s
cottons9312193cottons
coupons112710563coupons
couscous1246683couscous
covetous1347093covetous
covings134511243covings
covins114618063covi_ns
cowboys1735253cowboys
cowpies143314283cowpi_es
cowplops1743173cowplops
coxitis16238463coxitis
coydogs1434493coydogs
coypou13268403coypou_
coypus13389303co_ypus
cozies174521413cozi_es
croupous1245923croupous
cubitus11346783cubitus
cupids11369193cupi_ds
cupreous1255603cupreous
curios83218333curio_s
cymous1388403c_ymous
cyprus1335363cyp_rus
devious1138523devious
dopings11408783dopings
dubious1036893dubious
envious1037223envious
folios93915463folio_s
furious103110633furious
glorious946823glorious
iodous7311503io_dous
joyous16276763jo_yous
leprous938843leprous
logions86211293logions
lotions74614763lotions
lupous849433lup_ous
modiolus1143773modiolus
morions94014643morions
motions94215003motions
nimious937663nimious
nocuous946583nocuous
nodous7711333no_dous
notions74014483notions
obvious1244823obvious
ochrous1237943ochrous
olios54520853_olio_s
ominous949033_ominous
onions64016433_onions
opines84820703_opines
opioid9310083_opioid
opioids1036523_opioids
opium92812093_opi_um
opiums10307073_opiums
options93810603_options
opus66420593_op__us
osmious936003osmious
osmous8138183_osmous
pappous1057463pappous
pilous84717753__pilous
pilus75921063__pilus
pions75826393__pions
poilus82210573po_ilus
polios84019723polio_s
pompous1338063pompous
populous1245953populous
porous84419483po_rous
potions93417423potions
poyous112911623po_yous
ronions73313343ronions
rosinous847373rosinous
rubious938283rubious
sanious7514103sanious
scabious1246593scabious
scarious10610203scarious
scorpions1344213scorpions
serious73616283serious
simious939803simious
solidus8338113solidus
solions7513753solions
sopites93817173sopites
sopors85215203sop_ors
soukous1136413soukous
spinous9310443_spinous
tedious838443tedious
tompions12267003tompions
tophus115210363top_hus
topics104714583topi_cs
topis76025833topi__s
topos75726393top_o_s
torous64319033to_rous
tortious839023tortious
typhous1566323typhous
uxorious1544413uxorious
various103113103various
vicious1239493vicious
vodous1038603vo_dous
vomitous13215803vomitous
vomitus12215743vomitus

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272666.87619492.0
3Display Results2662660.0932860.2
 (SQL Overall)1786912667.37524229.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.