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

470 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
puppies10321261(None) 
buppies133011061buppies
guppies123310521guppies
pappies103214821pappies
poppies102816191poppies
yuppies14339261yuppies
buppie12288732buppie_
cuppier1368322cuppier
cuppiest1448192cuppiest
hippies142813742hippies
koppies153210012koppies
nappies114613392nappies
pappier103511592pappier
pappiest112611112pappiest
peppier10268322peppier
peppiest11278562peppiest
pippins10319752pippins
poppied11388982poppied
popples103011872popples
popsies112816462popsies
potpies113116172potpies
preppies1149682preppies
pulpier1148622pulpier
pulpiest1258432pulpiest
pulpits1137242pulpits
punkies134216802punkies
punties94520782punties
pupates113311432pupates
pupils10389912pu_pils
pupped105013272pupp_ed
puppet93514592pupp_et
puppets10317012puppets
pupping114412502pupping
purples112712822purples
pussies93615692pussies
putties94420022putties
supples11511282supples
supplies1268822supplies
uppiles11208262_uppiles
yippies14279292yippies
yuppie13297132yuppie_
apples104315763_apples
applies11311213applies
atopies92816433atopies
aunties73920073aunties
auspices1236443auspices
bubbies103913513bubbies
buddies113914353buddies
budgies115312513budgies
buggies114613813buggies
bullies94121893bullies
bumpier13359203bumpier
bumpiest1437873bumpiest
bunnies94415003bunnies
bupkes144811483bu_pkes
burdies104117563burdies
buries84633273bu_ries
burnies94017823burnies
busbies113011693busbies
busies85525263bu_sies
butties93217953butties
chappies172610093chappies
chippies17309753chippies
copies104130303_copies
coppices1638243coppices
cowpies143314283cowpies
crappies142911153crappies
croppies143111133croppies
cubbies133312883cubbies
cuddies113313263cuddies
cullies94419963cullies
cupids11369193cu_pids
cuppas12458593cupp_as
cupped134413983cupp_ed
cupper124313863cupp_er
cuppers133712193cuppers
cupping144312383cupping
cuppings15336053cuppings
cuprites1259023cuprites
cupules113210263cupules
curies84934023cu_ries
curries93723163curries
cuspides13306943cuspides
cuspids12427113cuspids
cuspis105010703cuspi_s
cuties84927363cu_ties
cutties93118843cutties
dapples1238993dapples
dippier123111393dippier
dippiest132511133dippiest
duchies133312313duchies
duckies143613813duckies
dummies123012133dummies
dumpier12409653dumpier
dumpiest1338743dumpiest
duperies11312813duperies
dupes86425933du_p_es
dupped124411643dupp_ed
dupping133711043dupping
durries83817353durries
duties74921903du_ties
empties11712243empties
espies83716803_espies
eupepsies1344073eupepsies
fipples14298653fipples
floppies1546813floppies
fuddies123211203fuddies
funnies104113603funnies
furies95126373fu_ries
gappier12369843gappier
gappiest13259473gappiest
gipsies1039903gipsies
gullies84717313gullies
gulpier1046953gulpier
gulpiest1137353gulpiest
gunnies83413123gunnies
gurries83515953gurries
gussies82813303gussies
gypsies1335953gypsies
happier143312033happier
happiest152411673happiest
harpies123818313harpies
hippie132811243hippie_
hippier143212103hippier
hippiest152611613hippiest
hoppier143110703hoppier
hoppiest152610723hoppiest
hopples142810713hopples
hubbies143211563hubbies
huipiles1344423huipiles
huipils1243533huipils
humpier143110723humpier
humpiest1538963humpiest
hunkies143214503hunkies
huppahs1743333huppahs
hurdies114015663hurdies
hurlies103315333hurlies
hurries103919653hurries
huskies143212073huskies
hussies103213293hussies
implies11312123implies
jumpier18317943jumpier
jumpiest1936863jumpiest
junkies183711693junkies
jupes145218553ju_p_es
juries134120633ju_ries
jutties143814003jutties
kelpies13289903kelpies
kewpies16246923kewpies
koppie14277873koppie_
lippier112710573lippier
lippiest122310613lippiest
loppier11369723loppier
loppiest122410103loppiest
luckies133313683luckies
luggies93011213luggies
lumpier113410143lumpier
lumpiest1239253lumpiest
lunies64723013lu_nies
lupines93912503lupines
lupins84514463lu_pins
lupuses936273lupuses
magpies12310363magpies
muddies113513943muddies
mudpuppies165613mudpuppies
muhlies1238933muhlies
mummies103812843mummies
murphies1536453murphies
murries94118673murries
muskies133614663muskies
muspikes1635233muspikes
myopies14309713myopies
nappes104515623napp_es
nappie104112263nappie_
nappier114411173nappier
nappiest122510883nappiest
nippier11319833nippier
nippiest12279973nippiest
nipples11319663nipples
nudies75217093nu_dies
ouphes113614633ou_phes
outlies72421993outlies
outvies102214243outvies
paddies113715723paddies
palsies94420273palsies
pandies104224503pandies
panpipes1135173panpipes
pansies94521983pansies
panties94230933panties
papacies1439473papacies
papains11312363papains
pappi84810893pappi__
pappose1047413pappose
pappous1057463pappous
pappus9408373papp_us
papules112411573papules
paries84742513p_aries
parries93925843parries
parties93230863parties
pasties94529813pasties
patsies93919483patsies
patties93425143patties
peavies122213403peavies
peeries93623023peeries
pennies94218813pennies
peonies93620153peonies
peoples11312213peoples
pepped103113393pepp_ed
pepper93512943pepp_er
peppers103311443peppers
peppily1335123peppily
peppiness1235183peppiness
pepping113511623pepping
pepsines1239883pepsines
pepsins11310433pepsins
peptics132610243peptics
peptides132610263peptides
peptids12239323peptids
peptizes21269853peptizes
perries93226603perries
phonies123717513phonies
pies66949603___pies
pieties9419223pieties
piggies113813483piggies
pigmies122610993pigmies
pimples133012423pimples
pinkies133818263pinkies
pinnies93318443pinnies
pipages1289423pipages
pipes96030143p_ip_es
pipier104913983p_ipier
pipiest113114493p_ipiest
pipits104713063p_ipits
pipkins15328183pipkins
pipped104516543pipp_ed
pippin92810303pippi_n
pipping113414743pipping
pities83828083p_ities
pixies154915513p_ixies
platies93722543platies
plies74526513__plies
poesies93217403poesies
pogies94123543p_ogies
pokies125921333p_okies
polies84034583p_olies
pommies133712843pommies
ponies84833463p_onies
poperies12316793poperies
popes95933813p_op_es
poplins11313153poplins
poppas93710713popp_as
popped104117813popp_ed
popper93615963popp_er
poppers103414863poppers
poppet92717323popp_et
poppets10338853poppets
popping113715413popping
popple92710983popple_
poppled11339233poppled
popsie103013053popsie_
porgies103017003porgies
porkies133416493porkies
porkpies1636193porkpies
posies84431433p_osies
posties93128813posties
potpie103412423potpie_
potsies93019483potsies
potties93723543potties
poussies1038113poussies
premies113823063premies
preppie1058093preppie_
preppier1156643preppier
preppiest1236973preppiest
prexies163415003prexies
pries74339533__pries
privies122414263privies
propines122618933propines
proxies163014933proxies
pubes94423403pu__bes
pubis94616473pu_bi_s
publics13207143publics
puces94924633pu__ces
puddles113613823puddles
pudgier11377723pudgier
pudgiest12297893pudgiest
puffier1547973puffier
puffiest1647313puffiest
puffins15278913puffins
puggier11309383puggier
puggiest12219223puggiest
puggries12166383puggries
pugrees10218523pugrees
puisnes937423puisnes
pukes114523023pu__kes
pules74538813pu__les
pulis74225603pu_li_s
pulped114612533pulp_ed
pulper103513273pulp_er
pulpers114612283pulpers
pulpily1436103pulpily
pulpiness1335603pulpiness
pulping123612323pulping
pulpit10310933pulpi_t
pulpless12224953pulpless
pulpous1177013pulpous
pulps95116483pulp__s
pulques1835323pulques
pulses83818663pu_lses
pumices1338273pumices
pumped133915563pump_ed
pumper124415553pump_er
pumpers133113673pumpers
pumping144213553pumping
pumpkins1843853pumpkins
pumpless14236373pumpless
pumps115520603pump__s
punches144816133punches
pundits10379293pundits
pungles104013713pungles
punier84519223pu_nier
puniest92918093pu_niest
punjis1536693punji_s
punkie123513613punkie_
punkier133512793punkier
punkiest149312663punkiest
punkins133111113punkins
punnier93511263punnier
punniest102511583punniest
pupae96515643pu_pae_
pupas95219283pu_p_as
pupate104213123pupate_
pupated12319353pupated
pupfish1735533pupfish
pupfishes1944313pupfishes
pupil94712983pu_pi_l
puppetries1343883puppetries
puppy114912413pupp__y
puppyish1742453puppyish
pups86032233pu_p__s
pupus94614043pu_p_us
purees84721683pu_rees
purfles122511843purfles
purges94421763pu_rges
purifies13311923purifies
purines94420763purines
purins83722653pu_rins
puris75332023pu_ri_s
purities10316283purities
purlieu938143purlieu
purlieus1034633purlieus
purlines103514053purlines
purlins93415423purlins
purple102712673purple_
purpled12299763purpled
purpler11289263purpler
purplest12249123purplest
purpose1137383purpose
purposes1237823purposes
purpures1276143purpures
purses84826373pu_rses
pursier94012753pursier
pursiest102812123pursiest
pursues94111373pursues
purtier93214093purtier
purtiest102414113purtiest
purview1534233purview
purviews1642533purviews
puses75532203pu__ses
pushes114621663pu_shes
pushier123611093pushier
pushiest133211713pushiest
pushpins1543343pushpins
pusses84322843pu_sses
pussier93711993pussier
pussiest102911753pussiest
pusslies1036173pusslies
puttees93612913puttees
puttie84116303puttie_
puttied103811163puttied
puttier93314503puttier
puttiers10288013puttiers
putzes174212523pu_tzes
puzzles17318973puzzles
pygmies15205673pygmies
pyxies18338293p_yxies
queries16315873queries
quippier2133773quippier
quippiest2243983quippiest
rappees113611453rappees
replies94521043replies
ripples113513293ripples
rubbies114114113rubbies
rubies84420343ru_bies
rugbies10339353rugbies
rummies113212793rummies
rumples113313133rumples
rupees8312573ru_pees
sappier113613113sappier
sappiest122612573sappiest
sophies12314613sophies
soppier112711583soppier
soppiest122511933soppiest
spies76037623__spies
spunkies14227583spunkies
spurries102311323spurries
sulkies114315763sulkies
sullies74122223sullies
supes75628303su_p_es
supines94216383supines
supped114415703supp_ed
supper104115433supp_er
suppers113314693suppers
supping123814533supping
supple10410203supple_
suppled1248463suppled
suppler1148433suppler
supplest1248933supplest
supplied1345983supplied
supplier1246603supplier
suppliers1354483suppliers
suppose1137973suppose
supposes1238203supposes
suppress1236443suppress
suspires1038203suspires
tawpies12309873tawpies
tippier113210543tippier
tippiest122310013tippiest
tipples112811253tipples
topples113111653topples
tummies113012033tummies
tunnies73614263tunnies
tupiks1235493tu_piks
tupped114013233tupp_ed
tupping123411663tupping
tushies10312163tushies
tutties73216473tutties
uglies7412323_uglies
umpires1137813_umpires
undies73821963_undies
unpiles92112783_unpiles
unpins82312383_unpins
unties64326923_unties
upases84112903_upases
updives1334713_updives
updries10209083updries
upped103715163_upp_ed
upper93714263_upp_er
uppers102912283_uppers
uppile10178503_uppile
uppiled12216593_uppiled
upping114013703_upping
uppings12257123_uppings
uppish1336633_uppish
uppity1335103_uppity
uprise82313693_uprise
uprises92012733_uprises
upsides10319633_upsides
upsizes18297163_upsizes
uptimes1177543_uptimes
weepies122811743weepies
wussies103411083wussies
yippie13277843yippie_
yummies14359533yummies
yuppieish1951033yuppieish
yuppifies1942693yuppifies
yuppify2042163yuppify
zappier20458373zappier
zappiest21228023zappiest
zippier20308193zippier
zippiest21248093zippiest

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340274708.14016465.2
3Display Results4704700.1732716.8
 (SQL Overall)1786914708.46921099.4
 
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.