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

164 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
plummet1327835(None) 
plummer13298521plummer
plummest14276411plummest
plummets14304771plummets
glummer12417982glummer
glummest13235562glummest
grummet12298872grummet
plumate1149802plumate
plumbed14317272plumbed
plumber13339982plumber
plume94819462plu_me_
plumed114412882plu_med
plumelet1276172plumelet
plumes104318132plu_mes
plumier113510042plumier
plumiest122110292plumiest
plummeted1642162plummeted
plummier1434122plummier
plummiest1544972plummiest
plummy15375662plumm_y
plumped14318642plumped
plumpen13276402plumpen
plumper13318772plumper
plumpest14236352plumpest
pummel12278042p_ummel
slummed12359272slummed
slummer113711202slummer
bluet75631193blu__et
blume95619893blu_me_
blumed114313643blu_med
blumes105917793blu_mes
bummed134211723_bummed
bummer124014103_bummer
bummest13298623_bummest
calumet11313293calu_met
chummed17396443chummed
clammed14369963clammed
clammer134211793clammer
clubmen1334253clubmen
clumber134011443clumber
clumped143610663clumped
crumpet133711063crumpet
cummer124414593_cummer
drummed13306323drummed
drummer12407503drummer
emmet94221383__emmet
flammed15377413flammed
flume106021173flu_me_
flumed124915263flu_med
flumes115119733flu_mes
flummery1833053flummery
flummox2141413flummox
flumped15377713flumped
fumet105630223_fu_met
glimmer12437713glimmer
glommed13265443glommed
glume85120463glu_me_
glumes94516813glu_mes
gourmet1059203gourmet
grommet12268453grommet
grummer12338783grummer
grummest13286363grummest
grummets13275033grummets
gummed123811663_gummed
gummer114615453_gummer
hummed144812673_hummed
hummer133615273_hummer
kummel14266173_kummel
lammed113915623_lammed
limmer104314793_limmer
limpet103518633_limpet
lumber103817773_lumber
lumen75220903_lu_men
lummox1733053_lummox
lumped114216963_lumped
lumpen104010663_lumpen
lumper103816653_lumper
lunet56835423_lu_net
mammet94319253_mammet
maumet103518883mau_met
mummed104411553_mummed
mummer93614543_mummer
pelmet103419243p_elmet
placet103923673pl_acet
placket15412873placket
planet84228353pl_anet
playlet1239523playlet
pledget113510653pledget
plowmen1434883plowmen
plucked16367963plucked
plucker15368243plucker
plugged12408043plugged
plugger11378433plugger
plum85122103plu_m__
plumage1245503plumage
plumaged1443573plumaged
plumages1335653plumages
plumb114514073plu_m_b
plumbers14418513plumbers
plumbery17315533plumbery
plumbic1543963plumbic
plumbs12459333plu_mbs
plumbum1543733plumbum
plumelets1372823plumelets
pluming123412043pluming
plumiped1533313plumiped
plummeting1742103plummeting
plumose1135963plumose
plump115315263plu_m_p
plumpens14304953plumpens
plumpers14357293plumpers
plumply1634223plumply
plumps124612613plu_mps
plums94619953plu_m_s
plumule1134303plumule
plumules1234663plumules
plumy124213233plu_m_y
plunder103810503plunder
plunge93811053plunge_
plunged11439523plunged
plunger104211243plunger
plunges104011613plunges
plunked14429593plunked
plunker133910653plunker
pluses83618073plu_ses
plusher124010383plusher
plushes124313673plushes
plushest13328283plushest
plusses93510693plusses
plutei8408903plu_tei
pommee122813283p_ommee
pommel12277453p_ommel
premeet11615153premeet
primmed14388853primmed
primmer134310163primmer
primmest14226693primmest
pullet84026333p_ullet
pummelo13284233p_ummelo
pummels13236543p_ummels
pumped133915563p_umped
pumper124415553p_umper
punnet83518843p_unnet
puppet93514593p_uppet
rummer104715483_rummer
rummest11279833_rummest
scummed14347913scummed
scummer13398753scummer
slammed123511103slammed
slammer113913033slammer
slimmed12368473slimmed
slimmer114211343slimmer
slimmest1235903slimmest
slumber113811003slumber
slummers12358933slummers
slummier1235473slummier
slummiest1335663slummiest
slummy13325863slumm_y
slumped123710153slumped
stummed12348553stummed
summed114014043_summed
summer104017713_summer
summit10311543_summit
trumpet113810723trumpet
unmet74426393__unmet

Search took 10 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.423422437.4
2DLD Change Limit1340271648.53015712.4
3Display Results1641640.0632603.2
 (SQL Overall)1786911649.01619819.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.