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

124 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
plumpens1430495(None) 
lumpens11298261_lumpens
plumpen13276401plumpen_
plumpers14357291plumpers
lumens85013972_lum_ens
lumpen104010662_lumpen_
lumpers113514482_lumpers
playpens1534072playpens
plumbers14418512plumbers
plumes104318132plum_e_s
plumipeds1641662plumipeds
plummets14304772plummets
plumped14318642plumpe_d
plumpened1642542plumpened
plumper13318772plumpe_r
plumpest14236352plumpest
plumping15277632plumping
plumpness1543472plumpness
plumps124612612plump__s
pumpers133113672p_umpers
acumens1136953acum_ens
albumens1244143album_ens
alumines10411673alumines
alumins9512983alum_ins
blumes105917793blum_e_s
bullpens1254083bullpens
bumpers133912053_bumpers
clampers143211883clampers
clumbers143910393clumbers
clumped143610663clumpe_d
clumping15319883clumping
clumps1215314643clump__s
crumpets14335943crumpets
dampens12348563_dampens
dumpers123412663_dumpers
erumpent1245453erumpent
flamens124611063flam_ens
flumes115119733flum_e_s
flumped15377713flumpe_d
flumping16287583flumping
flumps135112503flump__s
glumes94516813glum_e_s
glumness1135203glumness
glutens8437593glu_tens
humpers142713523_humpers
jumpers18399843_jumpers
lampers113817333_lampers
limens84618033_lim_ens
limpers113815223_limpers
limpets11329783_limpets
lippens11328533_lippens
lumbers113815913_lumbers
lumen75220903_lum_en_
lumped114216963_lumpe_d
lumper103816653_lumpe_r
lumping123314643_lumping
lumps95624983_lump__s
lupins84514463_lu_pins
mumpers133311363_mumpers
pampeans1444703p_ampeans
pampers133615933p_ampers
paupers114311073pau_pers
pigpens1235503p_igpens
platens94213983pl_atens
playpen1434693playpen_
pluckers16316553pluckers
pluggers12297023pluggers
plugless1133863plugless
plumages1335653plumages
plumbed14317273plumbe_d
plumbeous1542903plumbeous
plumber13339983plumbe_r
plumbery17315533plumbery
plumbing15286433plumbing
plumbings16213363plumbings
plumbness1543133plumbness
plumbous1444283plumbous
plumbs12459333plum__bs
plumbums1642943plumbums
plume94819463plum_e__
plumed114412883plum_e_d
plumelets1372823plumelets
plumier113510043plumie_r
plumiest122110293plumiest
pluming123412043plum_ing
plumiped1533313plumipe_d
plummer13298523plumme_r
plummest14276413plummest
plummet13278353plumme_t
plump115315263plump___
plumpening1742443plumpening
plumpish17164733plumpish
plumply1634223plump_ly
plums94619953plum___s
plumules1234663plumules
plunders11329823plunders
plungers11379393plungers
plunges104011613plunge_s
plunkers14328323plunkers
pluses83618073plu_se_s
plushes124313673plushe_s
plusses93510693plusse_s
pluteus9326243plu_teus
plutons938343plu_tons
pompons1338553p_ompons
pulpers114612283p_ulpers
pummels13236543p_ummels
pumped133915563p_umpe_d
pumper124415553p_umpe_r
pumping144213553p_umping
pumpkins1843853p_umpkins
pumpless14236373p_umpless
pumps115520603p_ump__s
puppets10317013p_uppets
rumens83611813_rum_ens
slumbers123110273slumbers
slummers12358933slummers
slumped123710153slumpe_d
slumping13359973slumping
slumps104313583slump__s
stumpers12318313stumpers
thumpers15365713thumpers
trumpets12315573trumpets
unpens82511013__unpens

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621248.54617103.0
3Display Results1241240.0462695.7
 (SQL Overall)1786911248.74820426.5
 
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.