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

240 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
cuprous114974(None) 
cupreous1255601cupreous
aurous64119262au_rous
cerous85821202c_erous
cirrous93111062cirrous
citrous93112982citrous
copious11311962copious
cumbrous1446172cumbrous
cuprum1236742cupr_um
cuprums1334452cuprums
curious93813562curious
cyprus1335362cypr_us
leprous938842leprous
lupous849432lup_ous
uprouse937222_uprouse
acarpous1245313acarpous
acerous9513333acerous
amorous9311133amorous
anurous7311553anurous
aprons8316993_aprons
aureus65314883au_reus
biparous1246923biparous
bulbous1138293bulbous
bullous9311663bullous
bupkus14385683bup_kus
burnous938823burnous
burros85114993burro_s
burrows12399093burrows
butyrous1345443butyrous
cachous14312563cachous
callous93516593callous
canorous10310193canorous
capons104119503cap_ons
capos94826073cap_o_s
capris10415073capr_is
caprock1736813caprock
caprocks1835943caprocks
captious122810563captious
captors113914983captors
carious93320283carious
carobs104818103c_arobs
carols85124983c_arols
carolus94612603c_arolus
caroms105619573c_aroms
carouse9614423c_arouse
carpus105514303c_arpus
carroms11512403carroms
carrots9714623carrots
caseous9312513caseous
cautious103110223cautious
cercus105013153c_ercus
cereus85215523c_ereus
ceros74726073c_ero_s
chiros114617773chiro_s
chirus114615693chir_us
chlorous1339203chlorous
chorus115014763chor_us
churros12427583churro_s
chylous15107263chylous
chymous1775683chymous
circus104310593c_ircus
cirrus8349173c_irrus
citreous1056843citreous
citrons92913223citrons
citrus83610913citr_us
claroes93113733claroes
claros84015113claro_s
coccous1038993coccous
comous10816493c_omous
congous103615073congous
coplots11511593coplots
copout10418773cop_out
copouts11311073cop_outs
coprahs14338153coprahs
copras103517153copr_as
cormous11312343cormous
cornus84816563c_ornus
corpus106015293c_orpus
coumarous1385763coumarous
coupons112710553coup_ons
couscous1246663couscous
coypous14248803coypous
cribrous1246003cribrous
crocs95722433c__rocs
crocus104813173c__rocus
crops96125233c__rops
cross75124503c__ross
croup95616783c__roup
croupous1245903croup_ous
croups104312553c__roups
crouse84619363c__rouse
crows105727313c__rows
crus65828483c__r_us
cuatros938253cuatro_s
cubitus11346783cubitus
cuckoos1585123cuckoos
cuirass934973cuirass
culprits1245583culprits
cultus85110733cu_ltus
cumulous1245273cumulous
cumulus1135453cumulus
cupels10310203cup_els
cupful1356423cup_ful
cupfuls1444343cupfuls
cupids11369193cup_ids
cupola10317693cup_ola
cupolas11277753cupolas
cuppas12458593cup_pas
cuppers133712193cuppers
cupric1249113cupr_ic
cuprite1159683cuprite
cuprites1259023cuprites
cups85430823cup___s
cupsful1453433cupsful
cupules113210263cupules
curbs94821653cu_r_bs
curds85725613cu_r_ds
curers84923183cu_rers
cures75645433cu_r_es
curets84922343cu_rets
curfs105122143cu_r_fs
curies84934023cu_ries
curios83218333cu_rios
curium10312503cu_rium
curiums1138503cu_riums
curls74927103cu_r_ls
curns74924273cu_r_ns
currans9310613currans
curries93723163curries
currs75624393cu_r_rs
curs65645543cu_r__s
curses85328273cu_rses
cursors93910023cursors
curves114619283cu_rves
cuscus1038113cu_scus
cussos84210003cusso_s
customs11348253customs
custos84014313custo_s
cutout8315923cu_tout
cutouts938013cu_touts
cymous1388393c_ymous
cypres1338523cypr_es
cypress1434653cypress
dubious1036883dubious
durocs9569703du_rocs
duros65422693du_ro_s
duteous838453duteous
estrous7712533estrous
euphroes1345993euphroes
euros54920243eu_ro_s
ferrous1049793ferrous
fibrous1237593fibrous
fucous11399863fu_cous
fulvous1334543fulvous
fungous11367433fungous
furious103110633furious
furors9310953fu_rors
furrows13327793furrows
fuscous1256673fuscous
guiros7389093guiro_s
gummous1236263gummous
gurus64318193gu_r_us
hugeous1137133hugeous
humorous1346443humorous
hydrous14197883hydrous
ichorous1346973ichorous
impious1137053impious
imporous1246303imporous
improvs1435003improvs
jupons15377803jup_ons
jurors1338283ju_rors
kurus98015633ku_r_us
lupus74512523lup__us
lustrous877803lustrous
luteous739273luteous
mucous104411653mu_cous
nitrous73512483nitrous
numerous1047833numerous
ocherous1346993ocherous
ochrous1237933ochrous
odorous837653odorous
onerous7312953onerous
outrows10311403outrows
pappous1057463pappous
parous84024163_parous
petrous92714423petrous
pious74621273__pious
porous84419473_porous
praus74621753__praus
proas75028803__proas
prods85523553__prods
profs105120893__profs
progs86624153__progs
proms95426403__proms
props95726883__props
pros65742783__pro_s
pross76529403__pross
proud84615483__proud
prows106327013__prows
pulpous1177003pulpous
pupus94614043pup__us
repros84216003repro_s
rubious938273rubious
rufous948263ru_fous
rugous739643ru_gous
ruinous739753ruinous
saporous1039053saporous
scabrous1245993scabrous
sclerous1047913sclerous
serous65023553_serous
sprout8419403_sprout
sprouts949983_sprouts
spumous1135853spumous
spurious1036963spurious
stuporous1144013stuporous
suberous10311783suberous
surplus936793surplus
torous64319023_torous
tuberous1047483tuberous
tumorous1046593tumorous
typhous1566323typhous
upbows1384683_upbows
updos8389513_updo_s
upgrows1334323_upgrows
uphroes1236303_uphroes
upprops1044223upprops
uproar8106933_uproar
uproars986453_uproars
uproot8314123_uproot
uproots937143_uproots
uprose82311483_uprose
uproused1135833_uproused
uprouses1037553_uprouses
uprush1135783_upr_ush
uptoss836093_uptoss
urus46426133_u_r_us
uveous936603_uveous
vaporous1346483vaporous
viperous1347613viperous
yupons11398353yup_ons

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.186960704.3
2DLD Change Limit1340272408.51615738.3
3Display Results2402400.0932580.6
 (SQL Overall)1786912408.79520317.3
 
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.