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

391 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
pebble123800(None) 
pebbled1445391pebbled
pebbles1337571pebbles
pebbly1545081pebbly
babble94017112babble
bobble94115142bobble
bubble94016592bubble
cobble123615262cobble
dabble114515192dabble
dibble114013842dibble
feeble1138252feeble
gabble113815722gabble
gobble113512982gobble
hobble133913432hobble
kebbie1435812kebbie
kibble143910952kibble
nebule848752nebule
nibble103713282nibble
nobble103814312nobble
nubble103813712nubble
pebblier1453262pebblier
peddle103512822peddle
pele65539552pe__le
penile82219602penile
people10310182people
pestle83215842pestle
pettle84116052pettle
rabble103818242rabble
rebbe9313162rebb_e
rubble104315672rubble
wabble133714842wabble
wobble133212312wobble
abbe87627193_abb_e
abele76323253_abele
able66340533__able
abubble1044523abubble
aedile73716653aedile
alible8311973alible
amble95924643_amble
arable81821003arable
babbled113612863babbled
babbler104012823babbler
babbles104416323babbles
bale66353843__bale
bauble103813213bauble
beadle93314683beadle
beagle93612593beagle
bedabble1243703bedabble
beebee10313063beebee
beetle8311673beetle
belle75827833be_lle
bible95119423_bible
bile66147183__bile
bobbled113811833bobbled
bobbles104514913bobbles
bole66448693__bole
brabble10349973brabble
bubale104014623bubale
bubbled113612123bubbled
bubbler103611783bubbler
bubbles104315963bubbles
bubbly124110353bubbly
bumble124216893bumble
burble104617703burble
cabbie122913353cabbie
cable95329913_cable
cobbled143411633cobbled
cobbler133311823cobbler
cobbles133814823cobbles
coble94823173_coble
dabbled133712073dabbled
dabbler124012153dabbler
dabbles124514773dabbles
debacle1237443debacle
debase94014473debase
debate94419193debate
debone93714783debone
debye1138903de_bye
decile94619213decile
deckle1312012453deckle
defile105216663defile
dele56843083de__le
dibbled133510843dibbled
dibbler124510283dibbler
dibbles124013333dibbles
doable93115243doable
double94013993double
drabble12238883drabble
dribble12368603dribble
dyable12308983dyable
dyeable1337303dyeable
eagle64219483_eagle
ebb72418633_ebb__
ebbed104111003_ebbed
ebbet93517293_ebbet
ebbs82411993_ebb_s
edible969353edible
edile64819493_edile
emblem1237583_emblem
enable83318483enable
exile126117653_exile
eyeable1239063eyeable
fable105824753_fable
febrile1237153febrile
feebler1235823feebler
feebly1436653feebly
female11310553female
ferule93413203ferule
fettle93713123fettle
fimble133611753fimble
foible11410383foible
fribble14287783fribble
fumble133214263fumble
gabbled134112453gabbled
gabbler124013303gabbler
gabbles124415413gabbles
gable85325523_gable
gamble115417183gamble
garble94118453garble
gelable101710733gelable
gentle74014513gentle
getable101712553getable
gobbled134010253gobbled
gobbler123310023gobbler
gobbles123512583gobbles
grabble12339643grabble
gribble12297273gribble
habile11515213habile
hebe96424703he_b_e
heckle153112093heckle
heddle114211163heddle
hewable15177823hewable
hobbled153310783hobbled
hobbler143710403hobbler
hobbles143313783hobbles
hubbly16478413hubbly
humble133615053humble
jebel145612143jebel_
jebels15418913jebels
jubile152910263jubile
jumble174012653jumble
kebbies1537253kebbies
keckle11359423keckle
kettle104311613kettle
kibbe135211973kibb_e
kibbled16367983kibbled
kibbles153510253kibbles
labile8315223labile
legible1035833legible
liable81415813liable
lobule82910063lobule
marble104219103marble
measle83513223measle
meddle103312763meddle
meikle1236653meikle
merle75824373me_rle
mettle83815723mettle
mobile103613543mobile
mumble123614343mumble
nebula857333nebula
nebulae955493nebulae
nebuly1135793nebuly
needle73310613needle
nestle63013953nestle
nettle64514583nettle
newbie11135413newbie
nibbled12389073nibbled
nibbler11379273nibbler
nibbles114011693nibbles
nimble103412943nimble
nobbled123511283nobbled
nobbler113211183nobbler
nobbles114014523nobbles
noble74420993_noble
nubbles113412433nubbles
nubbly13369673nubbly
nubile83212713nubile
obole75917143_obole
openable1247013openable
operable12410323operable
paddle104615143paddle
padle84522343p_adle
pale66055013p__ale
papule102212133papule
parable111819773parable
parle75836163p_arle
parole84425253parole
payable141711323payable
peace95026083pe_ace
peage84723563pe_age
peal68648103pe_al_
pealed95322803pe_aled
peals75235493pe_als
pearl75324463pearl_
pearled10411533pearled
pearler9310363pearler
pearls84715383pearls
pearly116414843pearly
pease75231113pe_ase
pebbliest1543713pebbliest
pebbling1535073pebbling
peccable1648103peccable
pedal86022503pedal_
pedaled113711873pedaled
pedaler103410693pedaler
pedalo93811143pedalo
pedals94316033pedals
pedate93117763pedate
peddled123410533peddled
peddler113210493peddler
peddles112913693peddles
pedicle1238963pedicle
pedler93614613pe_dler
pee56066513pe___e
peebeen1143903peebeen
peel65535613pe_el_
peelable1238553peelable
peeled94119703pe_eled
peeler83517383pe_eler
peels75226423pe_els
peerie83617893peerie
peeve104915253pe_eve
peewee11311963peewee
pegbox1844013pegbox
peise75825773pe_ise
peke105926203pe__ke
pekoe114612363pe_koe
pelage9515363pelage
peles75738083pe__les
pelf97031453pe__lf
pelite84323003pelite
pellet83326553pe_llet
pelt67651083pe__lt
penal75228373penal_
pence94924453pe_nce
pencel103812913pencel
pennae84314033pennae
penne75423853pe_nne
pensee8417313pensee
pensile92713543pensile
penult8314653penult
peopled1238483peopled
peopler1138073peopler
peoples11312213peoples
pepla9312863pe_pla
percale11314083percale
perdie94718513perdie
perdue93912633perdue
pere66450263pe__re
periblem1445513periblem
peril75425953peril_
periled10316293periled
perils84121853perils
perplex1836133perplex
perse75429523pe_rse
pertly115312543pertly
peruke123210393peruke
peruse84016843peruse
pesade9311103pesade
pestled102711433pestled
pestles93217693pestles
petal76526893petal_
petaled103614143petaled
petals84719813petals
petiole9311303petiole
petite84320653petite
petrale9312623petrale
petrel83111533petrel
pettable121710713pettable
pettled103611503pettled
pettles93916483pettles
pewee10319973pe_wee
peyote1139853peyote
phyle134111153p_hyle
pibal95217323pibal_
pibals103813083pibals
pickle144215653pickle
piddle103514913piddle
piebald1245503piebald
piehole12188553piehole
piffle14418233piffle
pile65649693p__ile
pilule8411123pilule
pimple123512963pimple
pinole83218783pinole
pintle83818263pintle
pizzle16279493pizzle
plebe95014873pleb_e
pliable111610323pliable
pokable15209503pokable
pole65951303p__ole
poodle93112043poodle
popple92710983popple
posable112212783posable
posole8314223posole
potable112115363potable
pottle84416103pottle
pozole1758913pozole
preamble1436373preamble
prebade12310283prebade
prebake1539093prebake
prebill1138803prebill
prefile123413183prefile
presale9416353presale
probable1439053probable
probe94320813prob_e
problem1335983problem
prole74527793p_role
puddle103914153puddle
pueblo1035553pueblo
puerile9310093puerile
pule65040953p__ule
pungle94413573pungle
purfle112511183purfle
purple102712673purple
puzzle16318603puzzle
quibble2034713quibble
rabbled123514423rabbled
rabbler113514093rabbler
rabbles113517973rabbles
ramble104519973ramble
rebate84424103rebate
rebbes10313533rebbes
rebel73421293rebel_
rebels84518133rebels
rebill84713253rebill
rebore86625643rebore
rebuke124010123rebuke
reddle83815913reddle
refile95122373refile
regale74821453regale
resale64025543resale
resile64627673resile
resole64624183resole
retable91820403retable
retile65929673retile
revile94921613revile
roble75223023_roble
rouble83913313rouble
rubbled124611623rubbled
rubbles113715113rubbles
rubbly133710613rubbly
ruble74521253_ruble
rumble103718813rumble
sable74732163_sable
scabble13168653scabble
sedile73517233sedile
seeable91113943seeable
selle54428313se_lle
semple103212753semple
senile63420213senile
settle63915663settle
sewable121911173sewable
speckle15297553speckle
stable83921643stable
stubble1136843stubble
suable83920553suable
subtle82113433subtle
table75429603_table
tapeable1238823tapeable
teazle15329553teazle
tele45040873te__le
temple102811333temple
tenable93214493tenable
treble8311663treble
tremble1138003tremble
tubule839853tubule
tumble103215643tumble
typeable1535233typeable
unable83819223unable
unbale83616403unbale
usable84012553usable
useable9911063useable
venule94411763venule
verbile1249863verbile
viable111613773viable
wabbled153311443wabbled
wabbler143511923wabbler
wabbles144013993wabbles
wabbly16348363wabbly
wamble134415753wamble
warble113516603warble
webbed1436433webbed
webbier1445423webbier
webby1537153webb_y
wimble133211923wimble
wobbled15349593wobbled
wobbler14329823wobbler
wobbles143412433wobbles
wobbly16347093wobbly
yabbie13308663yabbie

Search took 7 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127163915.89019136.8
3Display Results3913910.1263103.2
 (SQL Overall)1786913916.14229093.3
 
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.