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

142 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
cuprums133445(None) 
cuprum1236741cuprum_
aurums849382au_rums
cundums1235182cundums
cupfuls1444342cupfuls
cuprous1149742cuprous
curiums1138502curiums
cyprus1335362cypru_s
durums948152du_rums
quorums1843892quorums
alarums9408923alarums
antrums969173antrums
arums75517833__arums
asarums9467613asarums
aurum7614963au_rum_
bunkums1544053bunkums
bupkus14385683bupku_s
capfuls1436523capfuls
capris10415083capr_is
caroms105619573c_aroms
carpus105514303carpu_s
carroms11512403carroms
centrums1236913centrums
centums11398783centums
ceriums1139473ceriums
cesiums1136303cesiums
charms135218843char_ms
cherubs1434553cherubs
chetrums1543913chetrums
chirms135113983chir_ms
chirus114615693chiru_s
chorus115014773choru_s
chums125015833c__hums
cirrus8349173cirru_s
citrus83610923citru_s
coniums11311863coniums
copalms13367543copalms
copouts11311083copouts
coprahs14338153coprahs
copras103517153copr_as
corms95626223c_or_ms
corpus106015293corpu_s
crams96229153c__rams
crinums1135863crinums
cruds85815853c__ruds
crumb114313593c__rumb
crumbs12409233c__rumbs
crumbums1642733crumbums
crump115616423c__rump
crumps124514343c__rumps
crus65828483c__ru_s
cubisms13306883cubisms
cuirass934973cuirass
culms95314193cu__lms
culprits1245583culprits
cultus85110733cultu_s
cundum1136513cundum_
cupels10310203cup_els
cupful1356423cupfu_l
cupids11369193cup_ids
cupolas11277753cupolas
cuppas12458593cup_pas
cuppers133712213cuppers
cupreous1255603cupreous
cupric1249123cupr_ic
cuprite1159683cuprite
cuprites1259023cuprites
cups85430823cup___s
cupula10328433cup_ula
cupule103410723cup_ule
cupules113210263cupules
curbs94821653cu_r_bs
curcuma1344773curcuma
curcumas1454853curcumas
curds85725613cu_r_ds
curers84923193cu_rers
cures75645433cu_r_es
curets84922343cu_rets
curfs105122143cu_r_fs
curies84934023cu_ries
curios83218333cu_rios
curium10312503curium_
curls74927103cu_r_ls
curns74924283cu_r_ns
currans9310613currans
curries93723163curries
currs75624393cu_r_rs
curs65645543cu_r__s
curses85328273cu_rses
curule83614123cu_rule
curves114619283cu_rves
cuscus1038113cuscu_s
customs11348263customs
cutouts938033cutouts
cutups1036813cu_tups
cypres1338523cypr_es
cypress1434653cypress
cypruses1534313cypruses
drums85415873__drums
dumdums1343043dumdums
durum8513203du_rum_
estrums9208603estrums
ferrums1265983ferrums
forums114611843_forums
fulcrums1542353fulcrums
gurus64318193gu_ru_s
gypsums1541923gypsums
humdrums1642703humdrums
jorums15408093_jorums
jugums16104673ju_gums
kurus98015633ku_ru_s
labrums1175853labrums
larums83610533_larums
lupous849433lupou_s
lupus74512523lup_u_s
lustrums1044663lustrums
museums1134563museums
opiums10307073_opiums
outruns72911543outruns
peplums13145503peplums
plums94619953__plums
prams96125513__prams
prims95425933__prims
proms95426413__proms
pupus94614043pup_u_s
quorum1736023quorum_
rums64833473___rums
sacrums11388043sacrums
scrums104614253_scrums
septums1135743septums
serums83916303_serums
sprues84515763_sprues
sprugs94010173_sprugs
strums84716453_strums
subgums1235893subgums
supreme1137893supreme
supremes1238363supremes
supremo1145723supremo
supremos1245813supremos
thrums11429123_thrums
uprush1135783_uprush
urus46426143_u_ru_s

Search took 7 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.410435831.7
2DLD Change Limit1340271425.96622465.1
3Display Results1421420.0463087.0
 (SQL Overall)1786911426.42227824.8
 
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.