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

334 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
scummer1339875(None) 
cummer124414591_cummer
scammer133611971scammer
scummed14347911scummed
scummers14277781scummers
scummier1445081scummier
slummer113711201slummer
summer104017711s_ummer
bummer124014102_bummer
cumber124016702_cumber
cummers133713482_cummers
drummer12407502drummer
glummer12417982glummer
grummer12338782grummer
gummer114615452_gummer
hummer133615272_hummer
mummer93614542_mummer
plummer13298522plummer
rummer104715482_rummer
scammed14479542scammed
scammers14339772scammers
scamper134613162scamper
schemer1477952schemer
schmeer1475362schmeer
scrummed1554312scrummed
scuffer15328882scuffer
sculker13318322sculker
sculler99812152sculler
scummy15265222scumm_y
scunner9358242scunner
scupper1367422scupper
scutter93512172scutter
shammer144613142shammer
shimmer143310872shimmer
simmer104115352s_immer
skimmer15327532skimmer
slammer113913032slammer
slimmer114211342slimmer
slumber113811002slumber
slummed12359272slummed
slummers12358932slummers
slummier1235472slummier
spammer133410432spammer
spumier1137902spumier
stammer116013342stammer
stemmer113210182stemmer
strummer1234782strummer
stummed12348552stummed
stumper113610092stumper
summed114014042s_ummed
summers113616502s_ummers
summery14329412s_ummery
swimmer14297652swimmer
acumen1049013acu_men
acuter84412863acu_ter
assumer965363assu_mer
brimmer13348803brimmer
bummed134211723_bummed
bummers133712443_bummers
bumper123714343_bumper
calmer105216933_calmer
camber124418483_camber
camper124722213_camper
chimer135517203_chimer
chummed17396443chummed
chummier1734513chummier
clammer134211793clammer
clumber134011443clumber
comber125118503_comber
comer95832693_c_omer
crammer134010963crammer
crimmer133310773crimmer
crumber13339643crumber
crummier1435603crummier
cuber95222533_cu_ber
cucumber1642603cucumber
culler84322253_culler
culmed114610593_culmed
culver113010633_culver
cumbers134515413_cumbers
cummin1288783_cummin
cunner83915003_cunner
cupper124313863_cupper
curber104517053_curber
curer75030753_cu_rer
curler85221323_curler
curser84721473_curser
curter85320083_curter
cusser86016093_cusser
cuter74728233_cu_ter
cutler84718033_cutler
cutter84521003_cutter
dammer114317933_dammer
dimmer114112613_dimmer
drummed13306323drummed
drummers13316163drummers
dumber114414173_dumber
dumper114615213_dumper
emmer94314463__emmer
encumber1454143encumber
flummery1833053flummery
fumer105918233_fu_mer
fumier11310903_fumier
gammer1112318333_gammer
glimmer12437713glimmer
grimmer123510093grimmer
grummet12298873grummet
gummed123811663_gummed
gummers123712203_gummers
gummier12349473_gummier
hammer138120033_hammer
hemmer134112643_hemmer
hummed144812673_hummed
hummers143813063_hummers
humper134115883_humper
incumber1444553incumber
jammer174014133_jammer
jumper173612373_jumper
krimmer15376873krimmer
kummel14266173_kummel
limmer104314793_limmer
lumber103817773_lumber
lumper103816653_lumper
mammer94218863_mammer
mummed104411553_mummed
mummers103712843_mummers
mummery13336663_mummery
mumper123513523_mumper
number103913223_number
plumber13339983plumber
plumier113510043plumier
plummet13278353plummet
plummier1434123plummier
plumper13318773plumper
primmer134310163primmer
pummel12278043_pummel
pumper124415553_pumper
rammer103519653_rammer
rimmer103516033_rimmer
rummers113513653_rummers
rummier11309563_rummier
saucer84314103sau_cer
saucier9810283saucier
sauger74316253sau_ger
saunter72913453saunter
scaler84321603sc_aler
scalier94316913scalier
scalper113912923scalper
scamped144711963scamped
scampers143611033scampers
scamster1235303scamster
scanner94411813scanner
scanter94215183scanter
scarcer113911373scarcer
scarer84524603sc_arer
scarfer124511083scarfer
scarier94017873scarier
scarper114814823scarper
scatter93815173scatter
scauper11379453scauper
scepter1138353scepter
scheme1379633scheme_
schemed1577753schemed
schemers1576703schemers
schemes1489663schemes
schmear1484043schmear
schmeers1574833schmeers
schmoe13328333schmoe_
schmoes14308543schmoes
schusser1342973schusser
scimiter1236143scimiter
scoffer15317023scoffer
scolder103210333scolder
scooper113812033scooper
scooter93312873scooter
scorer84818253sc_orer
scorner9259763scorner
scoter83815483sc_oter
scourer93910433scourer
scourger1134723scourger
scouter93313323scouter
scouther1356943scouther
scowder13286853scowder
scowler12248173scowler
scrammed1555003scrammed
scraper114513413scraper
screamer12267873screamer
screwer124410063screwer
scriber113910963scriber
scrimper1455753scrimper
scrubber1434113scrubber
scubaed1236123scubaed
scudded12215933scudded
scuffed16298243scuffed
scuffers16307493scuffers
scuffler16286703scuffler
sculked14307183sculked
sculkers14306933sculkers
sculled102911693sculled
scullers103510483scullers
scullery13296333scullery
sculped12398253sculped
scum85924523scu_m__
scumbag1443573scumbag
scumble1337013scumble
scumbled1535053scumbled
scumbles1447023scumbles
scumless1254993scumless
scummiest1535213scummiest
scummily1743303scummily
scumming15256793scumming
scums95017423scu_m_s
scunners10357303scunners
scuppers1446543scuppers
scurfier13267053scurfier
scurvier13255883scurvier
scutcher15176963scutcher
scute75520943scu_te_
scutes85219193scu_tes
scutters103311023scutters
scuzzes1734403scuzzes
scuzzier1842713scuzzier
seamer84223613s_eamer
seamier93114633seamier
securer958253secu_rer
seemer84418043s_eemer
shammed153911423shammed
shammers153710843shammers
shammes144312833shammes
shimmed15338583shimmed
shimmers15269413shimmers
shimmery18265253shimmery
shucker163710103shucker
shudder12297323shudder
shunner10358643shunner
shunter103611733shunter
shusher13288113shusher
shutter103712143shutter
simmers113314613s_immers
simper103616293s_imper
skimmed16306053skimmed
skimmers16296463skimmers
skulker10325683skulker
slammed123511103slammed
slammers123511223slammers
slimier93212013slimier
slimmed12368473slimmed
slimmers12369633slimmers
slubber113010763slubber
slugger93610683slugger
slumbers123110273slumbers
slumbery15296043slumbery
slummy13325863slumm_y
slumped123710153slumped
smugger11327053smugger
snubber11277733snubber
snuffer13318853snuffer
snugger9318313snugger
somber103714003s_omber
sounder83315383sounder
soupier93111753soupier
sourer63620213sou_rer
souter64225923sou_ter
souther104116303souther
spammed14348523spammed
spammers14378693spammers
spudder11256553spudder
spume95817313spu_me_
spumed114711543spu_med
spumes1021314883spu_mes
spurner9269653spurner
spurrer93710223spurrer
spurter94013003spurter
sputter94014053sputter
squarer163410663squarer
squirmer1934373squirmer
stammel11607533stammel
stammers123611523stammers
stamper113714403stamper
steamer93313093steamer
stemmed12278153stemmed
stemmers12378443stemmers
stemmery15334693stemmery
stemmier1245253stemmier
stomper114111233stomper
strummed1344473strummed
strummers1333693strummers
studier82510053studier
stuffer13349793stuffer
stuiver10447083stuiver
stumbler1235813stumbler
stumped124210153stumped
stumpers12318313stumpers
stumpier1255883stumpier
stunner7349193stunner
stutter72911463stutter
suaver93014233s_uaver
suber74924503s_u_ber
sucker124120663s_ucker
suckier133613973suckier
suckler133413093suckler
sudser73511283s_udser
suer45334033s_u__er
suffer124314513s_uffer
suiter64121813s_uiter
sulker104015923s_ulker
summa94713313s_umm_a
summae103911013s_ummae
summary14297353s_ummary
summas104313163s_ummas
summered1338143s_ummered
summerly15275103s_ummerly
summit10311543s_ummit
summon1037623s_ummon
summoner1245533s_ummoner
sumpter1138873s_umpter
sunder74019823s_under
super74924483s_u_per
supper104115433s_upper
surer54833093s_u_rer
surfer93515883s_urfer
surger74320093s_urger
sutler63718393s_utler
swamper14349313swamper
swarmer1247803swarmer
swimmers15276693swimmers
swimmier15174313swimmier
thrummer1542933thrummer
thumper14356953thumper
trimmer113610833trimmer
tummler11266613_tummler
umber94617593__umber
yammer133713183_yammer
yummier14306843_yummier

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.1531167915.0
2DLD Change Limit1340273347.50017870.3
3Display Results3343340.1262650.8
 (SQL Overall)1786913347.77922970.9
 
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.