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

238 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
pummels1323654(None) 
kummels15234791kummels
pommels13235781pommels
pummel12278041pummel_
pummelo13284231pummelo
pummelos14223101pummelos
bummers133712442bummers
cummers133713482cummers
gummers123712202gummers
hummers143813062hummers
kummel14266172kummel_
mummers103712842mummers
plummets14304772plummets
pommel12277452pommel_
pumelo10257112pu_melo
pumelos11196092pu_melos
pummeled1543372pummeled
pumpers133113672pumpers
rummers113513652rummers
summers113616502summers
umbels104510592_umbels
bulbels11398013bulbels
bumbles134016843bumbles
bummalo1353793bummalo
bummalos1442873bummalos
bummed134211723bumme_d
bummer124014103bumme_r
bummest13298623bummest
bumpers133912053bumpers
bushels124110713bushels
camels105217083_camels
compels133210883compels
cormels113813373cormels
cudgels1135333cudgels
cumbers134515413cumbers
cummer124414593cumme_r
cummins1358963cummins
cupels10310203cu_pels
dammers123214273dammers
damsels10126703damsels
dimmers123811563dimmers
drummers13316163drummers
duels65619233du__els
duffels14296453duffels
dummies123012133dummies
dumpers123412663dumpers
emmers104013223_emmers
emmets10349153_emmets
enamels9128163enamels
femmes135410213femme_s
fuels87117353fu__els
fumbles143514413fumbles
fumers113613383fu_mers
fumes105224703fu_me_s
fumets114311813fu_mets
funnels10348173funnels
fusels94412453fu_sels
gammers123214563gammers
gimels938893_gimels
gimmals12225823gimmals
gimmes113010903gimme_s
grummets13275033grummets
gumless10228273gumless
gummas114810513gumm_as
gummed123811663gumme_d
gummer114615453gumme_r
gummous1236263gummous
gunnels8358563gunnels
gunsels8338133gunsels
hammals14409223hammals
hammers144216063hammers
hemmers143310843hemmers
humbles143215803humbles
hummed144812673humme_d
hummer133615273humme_r
hummus1336243humm_us
humpers142713523humpers
humvees1534683humvees
impels10389523_impels
jammers183710703jammers
jumbals18106533jumbals
jumbles183013323jumbles
jumpers18399843jumpers
jurels133710583ju_rels
kugels1146073ku_gels
limmers113413083limmers
lumbers113815913lumbers
lumens85013973lu_mens
lumpens11298263lumpens
lumpers113514483lumpers
mammals10389273mammals
mammees104411143mammees
mammers104615693mammers
mammets103911113mammets
mammeys13376723mammeys
mels65941533___mels
mumbles133014433mumbles
mummed104411553mumme_d
mummer93614543mumme_r
mummery13336663mummery
mummies103812843mummies
mumms85513153mumm__s
mumpers133311373mumpers
mussels9419843mussels
mutuels935943mutuels
numbers113711243numbers
numbles113814273numbles
nutmegs10132903nutmegs
ousels64815273ou_sels
ouzels15408703ou_zels
palmers113513623palmers
pampers133615933pampers
panels84716523p_anels
parcels113712663parcels
parrels94713493parrels
passels93913023passels
pastels95215183pastels
peels75226423p__eels
pelmets11309693pelmets
pencels113610053pencels
petrels9279373petrels
pimples133012423pimples
pixels15478533p_ixels
plumbers14418513plumbers
plumes104318133plume_s
plummer13298523plumme_r
plummest14276413plummest
plummet13278353plumme_t
plumpens14304953plumpens
plumpers14357293plumpers
plumules1234663plumules
pomelo10238663p_omelo
pomelos11218133p_omelos
pomes94833933p_ome_s
pommee122813283pomme_e
pommeled1543103pommeled
pommies133712843pommies
premeds12389593premeds
primely1457723primely
primers114215673primers
primes104225263prime_s
propels113412843propels
pubes94423403pu_be_s
puces94924633pu_ce_s
puckers153514673puckers
puddles113613823puddles
puffers15349203puffers
pugrees10218523pugrees
pukes114523023pu_ke_s
pulers83820283pu_lers
pules74538813pu_le_s
pullers93618483pullers
pullets94015163pullets
pulleys12399143pulleys
pulls74425053pu__lls
pulpers114612283pulpers
puls65437563pu___ls
pulsers94213153pulsers
pulses83818663pulse_s
pumas95121563pu_m_as
pumicers1434353pumicers
pumices1338273pumices
pummeling1643603pummeling
pummelled1643073pummelled
pumped133915563pumpe_d
pumper124415553pumpe_r
pumpless14236373pumpless
pumps115520603pu_m_ps
pungles104013713pungles
punkers133714853punkers
punkeys16366493punkeys
punners94114233punners
punnets9409263punnets
punters93617043punters
pupils10389913pu_pils
puppets10317013puppets
purees84721683pu_rees
purely114013633pu_rely
purfles122511843purfles
purgers104714003purgers
purges94421763purge_s
purls74723353pu__rls
purples112712833purples
pursers93916093pursers
purses84826373purse_s
purveys15615903purveys
puses75532203pu_se_s
pushers123814503pushers
pushes114621663pushe_s
pusleys12286233pusleys
pusses84322843pusse_s
puttees93612913puttees
putters94219193putters
putzes174212523putze_s
puzzles17318973puzzles
rammers113715043rammers
rimmers113812883rimmers
rubels84112993ru_bels
rumbles114018393rumbles
rumens83611813ru_mens
rummer104715483rumme_r
rummest11279833rummest
rummies113212793rummies
rumples113313133rumples
runnels7329153runnels
samiels939763samiels
scummers14277783scummers
simmers113314613simmers
simnels976103simnels
slummers12358933slummers
spammers14378693spammers
spumes1021314883spu_me_s
stammels12495563stammels
sumless92611123sumless
summas104313163summ_as
summed114014043summe_d
summer104017713summe_r
summerly15275103summerly
summery14329413summery
summits1137983summits
summons1158003summons
tramels93812493tramels
trammels12295413trammels
trommels12254333trommels
tumbles113816023tumbles
tumbrels12285733tumbrels
tummies113012033tummies
tummler11266613tummler
tummlers12295703tummlers
tunnels7328723tunnels
umbel93612843_umbel_
umbers104215213_umbers
umbles103817493_umbles
unmews11326523_unmews
wadmels1334303wadmels
wurzels1934083wurzels
yammers143410323yammers
yummies14359533yummies

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.406440125.6
2DLD Change Limit1340272386.50020619.5
3Display Results2382380.0763131.6
 (SQL Overall)1786912386.98225593.1
 
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.