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

464 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
lumpier11341014(None) 
bumpier13359201bumpier
clumpier1435581clumpier
dumpier12409651dumpier
glumpier1334871glumpier
humpier143110721humpier
jumpier18317941jumpier
lumper103816651lump_er
bumper123714342bump_er
campier133313272campier
clumsier1234732clumsier
cuppier1368322cuppier
dumper114615212dump_er
frumpier1534172frumpier
fumier11310902fum_ier
gimpier12247932gimpier
grumpier1334802grumpier
gulpier1046952gulpier
gummier12349472gummier
hempier14319002hempier
humper134115882hump_er
jumper173612372jump_er
lambier113611632lambier
limbier11349092limbier
limier83518712lim_ier
limper104117852limp_er
limpsier1234432limpsier
lippier112710572lippier
loopier93711192loopier
loppier11369722loppier
luckier133811532luckier
lumber103817772lum_ber
lumped114216962lump_ed
lumpen104010662lump_en
lumpers113514482lump_ers
lumpiest1239252lumpiest
lumpily1476562lumpily
lumping123314642lumping
lumpish14127382lumpish
lunier64617602lu_nier
lustier73813502lustier
luthier1038232luthier
mumper123513522mump_er
plumier113510042plum_ier
plummier1434122plummier
plumper13318772plump_er
pulpier1148622pulpier
pumper124415552pump_er
rummier11309562rummier
rumplier1235302rumplier
slummier1235472slummier
stumpier1255882stumpier
sumpter1138872sumpter
umpire1047882_umpire
vampier14308232vampier
wimpier14248042wimpier
yummier14306842yummier
ampler104313303_ampler
bluesier1034943bluesier
blurrier1035153blurrier
buffier1568403buffier
buggier113611343buggier
bulgier103911213bulgier
bulkier134111513bulkier
bullier94116433bullier
bumbler134013233bumbler
bummer124014103bum_mer
bumped134414003bump_ed
bumpers133912053bump_ers
bumpiest1437873bumpiest
bumpily1665653bumpily
bumping143812493bumping
buppie12288733buppie_
buppies133011063buppies
burier84324653bu_rier
burlier93514413burlier
burrier93613543burrier
bushier123712813bushier
busier85219723bu_sier
bustier93916153bustier
camper124722213camp_er
chummier1734513chummier
clammier1435843clammier
clamper134012993clamp_er
clubbier1434833clubbier
clumber134011443clum_ber
clumped143610663clump_ed
clumpiest1535343clumpiest
clumping15319883clumping
clumpish17164893clumpish
clunkier14345793clunkier
comfier1439163comfier
compeer133811553compeer
compiler1438373compiler
complier14310253complier
copier103722893_copier
crampier14288903crampier
crepier1139733crepier
crimpier14287323crimpier
crumbier1456363crumbier
crummier1435603crummier
crumplier1543783crumplier
cumber124016703cum_ber
cummer124414593cum_mer
cupper124313863cu_pper
curdier103312613curdier
curlier93314183curlier
currier93316693currier
curvier123110663curvier
cushier123610833cushier
damper114117753damp_er
dimplier1336673dimplier
dippier123111393dippier
dopier93515923_dopier
drumlier1134523drumlier
duckier143911793duckier
dumber114414173dum_ber
dummied13346723dummied
dummies123012133dummies
dumped123814493dump_ed
dumpers123412663dump_ers
dumpiest1338743dumpiest
dumpily1566233dumpily
dumping133712913dumping
dumpish15116113dumpish
dumpster1344053dumpster
dungier9368583dungier
duper85519003du_p_er
duskier12409423duskier
dustier83814133dustier
elmier839813elm_ier
empire1039313_empire
emptier1187603_emptier
flamier123112143flam_ier
flappier1544293flappier
flimsier1344133flimsier
floppier1554633floppier
fluffier13264333fluffier
flukier14397853flu_kier
flumped15377713flump_ed
flumping16287583flumping
flutier103011553flu_tier
fubsier12367763fubsier
fuggier12348963fuggier
fumbler143610813fumbler
fumer105918233fum__er
funkier14349983funkier
funnier103210163funnier
furrier103513643furrier
furzier19318093furzier
fussier103610673fussier
fustier104213933fustier
fuzzier18256523fuzzier
gambier124711963gambier
gamier93617933gam_ier
gammier123711193gammier
gappier12369843gappier
gemmier12337383gemmier
glimpser1342663glimpser
gloppier1354673gloppier
gluier7310263glu__ier
glummer12417983glum_mer
glumpiest1434943glumpiest
glumpily1643593glumpily
goopier103910573goopier
grapier103712603grapier
gripier103210323gripier
gulfier1137793gulfier
gulper93410213gulp_er
gummer114615453gum_mer
gunkier12369553gunkier
guppies123310523guppies
gushier113110073gushier
gustier83813863gustier
gutsier8389823gutsier
guttier83911103guttier
hammier143510653hammier
hamper134518653hamp_er
happier143312033happier
hempie132410563hempie_
hippier143212103hippier
homier116416993hom_ier
hoppier143110703hoppier
huffier1637493huffier
hulkier14328973hulkier
humaner12257663humaner
humbler143411943humbler
hummer133615273hum_mer
humped144015243hump_ed
humpers142713523hump_ers
humphed1835423humphed
humpiest1538963humpiest
humping153213073humping
hunkier144512143hunkier
hurrier103412933hurrier
huskier14369753huskier
jammier18408023jammier
jimper17389863jimp_er
juicier1635463juicier
jumbler183910273jumbler
jumped183511553jump_ed
jumpers18399843jump_ers
jumpiest1936863jumpiest
jumpily2174983jumpily
jumping19319803jumping
juniper1634023juniper
junkier18339493junkier
kludgier1432463kludgier
klutzier2142193klutzier
lacier84020093l_acier
lakier104716273l_akier
lamber104418493lam_ber
lambie103213663lambie_
lambies113015103lambies
lamer75233703lam__er
lamped114017543lamp_ed
lampers113817333lamp_ers
lamping123116003lamping
lampion11278303lampion
lamprey1434863lamprey
lamster9109913lamster
lankier113711633lankier
lapper104319953l_apper
lapser84113143l_apser
lardier83518343lardier
larkier113711523larkier
lathier10310833lathier
lazier154214613l_azier
leadier83212723leadier
leafier10329833leafier
leakier114010993leakier
leaper88118943leap_er
learier73415663learier
leavier10319993leavier
ledgier9458493ledgier
leerier73111503leerier
leggier9368233leggier
lempira1144193lempira
leper74820743l_ep_er
levier94013873l_evier
lier45942463l___ier
limber104316773lim_ber
limiter92710853limiter
limmer104314793lim_mer
limner84112863lim_ner
limped114817123limp_ed
limpers113815223limp_ers
limpet103518633limp_et
limpid11389743limpi_d
limping124614103limping
limpsey14365093limpsey
lingier84113373lingier
linier64423783l_inier
lintier73613793lintier
lipper104219633l_ipper
lisper84114433lisp_er
livier97514593l_ivier
loamier9349163loamier
loftier1037763loftier
loggier93811143loggier
logier75015733l_ogier
loonier73312673loonier
looper83817113loop_er
loper75129233l_op_er
lopper103717203l_opper
loudlier934943loudlier
lousier72411623lousier
lowlier10338903lowlier
lubber104214623lu_bber
lucifer1234603lucifer
luckie123611413luckie_
luckies133313683luckies
luger65322083lu__ger
lugger83916553lu_gger
luggie8318903luggie_
luggies93011213luggies
luller63415483lu_ller
lumbar103610593lum_bar
lumberer12177583lumberer
lumbers113815913lum_bers
lumen75220903lum__en
lumina84613543lum_ina
lump86531703lump___
lumpens11298263lumpens
lumpfish1843053lumpfish
lumpiness1336483lumpiness
lumps95624983lump__s
lumpy126615913lump__y
luncher123111413luncher
lunger75720413lu_nger
lunies64723013lu_nies
lunker104718343lu_nker
lupin75215843lu_pi_n
lupine84013533lu_pine
lupines93912503lu_pines
lupins84514463lu_pins
lurcher12338133lurcher
lurer54625313lu__rer
lurker103613293lu_rker
lusher93818763lu_sher
luster64023673lu_ster
luthiers1135163luthiers
mopier103914783_mopier
muckier153411473muckier
muddier114110013muddier
muggier11288943muggier
mumbler133510913mumbler
mummer93614543mum_mer
mummied11327103mummied
mummies103812843mummies
mumped133813163mump_ed
mumpers133311363mump_ers
mumping143411633mumping
murkier133110263murkier
mushier123813583mushier
muskier134312723muskier
mussier93314353mussier
mustier94017953mustier
muzzier17326553muzzier
nappier114411173nappier
nippier11319833nippier
nubbier11308133nubbier
number103913223num_ber
nutsier7329253nutsier
nuttier73112023nuttier
outlier72216143outlier
pamper124316663pamp_er
pappier103511593pappier
peppier10268323peppier
pier66035293___pier
pimplier1445413pimplier
pipier104913983_pipier
pluckier16295073pluckier
plumber13339983plum_ber
plumiped1533313plumiped
plummer13298523plum_mer
plumped14318643plump_ed
plumpen13276403plump_en
plumpers14357293plump_ers
plumping15277633plumping
plumpish17164733plumpish
plunkier14305323plunkier
plushier1375193plushier
pudgier11377723pudgier
puffier1547973puffier
puggier11309383puggier
pulper103513273pulp_er
pumicer1335063pumicer
pumped133915563pump_ed
pumpers133113673pump_ers
pumping144213553pumping
punier84519223pu_nier
punkier133512793punkier
punnier93511263punnier
puppies103212613puppies
purpler11289263purpler
pursier94012753pursier
purtier93214093purtier
pushier123611093pushier
pussier93711993pussier
puttier93314503puttier
quakier20239203quakier
querier16310013querier
quipper2095813quipper
quippier2133773quippier
rammier112811023rammier
rapier84019993_rapier
raspier93110633raspier
rimier83916263rim_ier
romper104213683romp_er
ropier84118803_ropier
roupier9319493roupier
rubier84814733ru_bier
ruddier9338523ruddier
rulier65016353ru_lier
rumbler113514113rumbler
rummer104715483rum_mer
rummies113212793rummies
rumple103913013rumple_
rumpled123810013rumpled
rumples113313133rumples
runnier74010113runnier
runtier73512853runtier
rushier103411973rushier
rustier74416363rustier
ruttier73412283ruttier
sampler113212013sampler
sappier113613113sappier
schlumpier1941473schlumpier
scummier1445083scummier
seepier92912013seepier
simper103616293simp_er
simpler112910863simpler
skimpier1634293skimpier
sleepier1036783sleepier
slimier93212013slim_ier
slimpsier1343023slimpsier
slimsier1085213slimsier
slippier1256533slippier
sloppier1255703sloppier
sludgier1034823sludgier
slumber113811003slum_ber
slummer113711203slum_mer
slumped123710153slump_ed
slumping13359973slumping
slushier1135983slushier
sluttier836453sluttier
soapier93411713soapier
soppier112711583soppier
soupier93111753soupier
spier75728033__spier
spumier1137903spum_ier
stumper113610093stump_er
suckier133613973suckier
sudsier868773sudsier
sulkier113811963sulkier
summer104017713sum_mer
sumpters1238023sumpters
sunnier73412153sunnier
super74924483su_p_er
supper104115433su_pper
suppler1148433suppler
supplier1246603supplier
surfier102613543surfier
surlier72915443surlier
suspire937803suspire
swampier1544593swampier
tamper104618513tamp_er
temper103914093temp_er
tempter11358213tempter
thumper14356953thump_er
tippier113210543tippier
trampier12318233trampier
tubbier11237743tubbier
tuftier1096603tuftier
tumbler113412823tumbler
tummies113012033tummies
tummler11266613tummler
tumped114216233tump_ed
tumping123114243tumping
turfier10249793turfier
typier1137333_typier
uglier748953_uglier
umber94617583_um_ber
umped104717273_ump_ed
umping114815323_umping
umpired1235783_umpired
umpires1137813_umpires
upper93714263_u_pper
vamper134212653vamp_er
vampire14296673vampire
vuggier12296813vuggier
waspier12259053waspier
weepier12319273weepier
wispier12249403wispier
wombier1436533wombier
wussier10408083wussier
yuckier16358533yuckier
yukkier13263893yukkier
yummies14359533yummies
yuppie13297133yuppie_
yuppies14339263yuppies
zappier20458373zappier
zippier20308193zippier

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.1561145455.1
2DLD Change Limit1340274647.61017612.0
3Display Results4644640.1732682.1
 (SQL Overall)1786914647.93922508.0
 
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.