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

390 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
pebbles133757(None) 
pebble1238001pebble_
pebbled1445391pebbled
babbles104416322babbles
bobbles104514912bobbles
bubbles104315962bubbles
cobbles133814822cobbles
dabbles124514772dabbles
dibbles124013332dibbles
gabbles124415412gabbles
gobbles123512582gobbles
hobbles143313782hobbles
kebbies1537252kebbies
kibbles153510252kibbles
nibbles114011692nibbles
nobbles114014522nobbles
nubbles113412432nubbles
pebblier1453262pebblier
pebbliest1543712pebbliest
pebbly1545082pebbl_y
peddles112913702peddles
peles75738082pe__les
peoples11312212peoples
pestles93217692pestles
pettles93916482pettles
rabbles113517972rabbles
rebbes10313532rebb_es
rubbles113715112rubbles
wabbles144013992wabbles
wobbles143412432wobbles
abbes96723523_abb_es
abeles84719393_abeles
ables75935543__ables
aediles83413903aediles
ambles105121863_ambles
arables91814973arables
babble94017113babble_
babbled113612863babbled
babbler104012823babbler
babblers113510353babblers
bales76250083__bales
baubles113611863baubles
beadles103414733beadles
beagles103212123beagles
bedabbles1343043bedabbles
beebees1138013beebees
beetles9312083beetles
belles85325993be_lles
bibles104617643_bibles
biles75542143__biles
bobbies103714563bobbies
bobble94115143bobble_
bobbled113811833bobbled
boles75448603__boles
brabbles11349753brabbles
bubales113513343bubales
bubbies103913513bubbies
bubble94016593bubble_
bubbled113612123bubbled
bubbler103611783bubbler
bubblers11448943bubblers
bubblies1166773bubblies
bumbles134016843bumbles
burbles114916803burbles
cabbies133115163cabbies
cables104527553_cables
cobble123615263cobble_
cobbled143411633cobbled
cobbler133311823cobbler
cobblers14359593cobblers
cobles104622883_cobles
cubbies133312883cubbies
dabble114515193dabble_
dabbled133712073dabbled
dabbler124012153dabbler
dabblers13379363dabblers
debacles1335723debacles
debases103814133debases
debates103718533debates
debones103315113debones
debtless1135653debtless
debyes1238103de_byes
deciles104417723deciles
deckles143312803deckles
defiles114016843defiles
deles65139253de__les
derbies103016053derbies
dibble114013843dibble_
dibbled133510843dibbled
dibbler124510283dibbler
dibblers13377583dibblers
dobbies124113063dobbies
doubles103113353doubles
drabbles13308523drabbles
dribbles13348393dribbles
eagles73819163_eagles
ebbed104111003_ebb_ed
ebbet93517293_ebb_et
ebbets10376833_ebbets
ebbs82411993_ebb__s
edibles1048003edibles
ediles74016983_ediles
emblem1237583_emblem
emblems1335043_emblems
enables92813123enables
exiles134816403_exiles
fables114921673_fables
feeble1138253feeble_
feebler1235823feebler
feeblest1336913feeblest
females12310663females
ferules103112723ferules
fettles103912733fettles
fimbles143510663fimbles
foibles1238853foibles
fribbles15287713fribbles
fumbles143514413fumbles
gabble113815723gabble_
gabbled134112453gabbled
gabbler124013303gabbler
gabblers134110083gabblers
gables94222333_gables
gambles124016203gambles
garbles104016923garbles
gentles83714343gentles
gobble113512983gobble_
gobbled134010253gobbled
gobbler123310023gobbler
gobblers13308343gobblers
grabbles13339893grabbles
gribbles13307363gribbles
hebes105521673he_b_es
heckles163711383heckles
heddles123311623heddles
herbless1336663herbless
hobbies143813343hobbies
hobble133913433hobble_
hobbled153310783hobbled
hobbler143710403hobbler
hobblers15308513hobblers
hubbies143211563hubbies
humbles143215803humbles
jebels15418913jebel_s
jubiles16289373jubiles
jumbles183013323jumbles
kebbie1435813kebbie_
keckles12318763keckles
kettles113411613kettles
kibbes143811193kibb_es
kibble143910953kibble_
kibbled16367983kibbled
lobbies113612463lobbies
lobules92510813lobules
marbles114516653marbles
measles92412753measles
meddles113213253meddles
merles85322763me_rles
mettles94115023mettles
mobiles112813123mobiles
mumbles133014433mumbles
nebulas957583nebulas
nebule848753nebule_
needles83211563needles
nestles73015463nestles
nettles73214083nettles
newbies12147423newbies
nibble103713283nibble_
nibbled12389073nibbled
nibbler11379273nibbler
nibblers12306543nibblers
nobble103814313nobble_
nobbled123511283nobbled
nobbler113211183nobbler
nobblers12318563nobblers
nobles83319723_nobles
nombles113212343nombles
nubble103813713nubble_
numbles113814273numbles
oboles83815833_oboles
paddles113515643paddles
padles95221123p_adles
pales75753803p__ales
papules112411573papules
parables121613563parables
parles86334403p_arles
paroles95025883paroles
payables15166483payables
peaces106324083pe_aces
peaches144120053peaches
peages94321843pe_ages
peakless14236683peakless
pealed95322803pe_aled
peals75235493pe_al_s
pearled10411543pearled
pearler9310373pearler
pearlers1039033pearlers
pearls84715393pearl_s
peases85229473pe_ases
peavies122213403peavies
pebbling1535073pebbling
pedaled113711883pedaled
pedaler103410693pedaler
pedalers11239393pedalers
pedalos10329703pedalos
pedals94316033pedal_s
peddle103512823peddle_
peddled123410533peddled
peddler113210493peddler
peddlers12298533peddlers
pedes85327283pe__des
pedicles1338683pedicles
pedler93614613pe_dler
pedlers103013273pe_dlers
peebeen1143903peebeen
peebeens1243063peebeens
peeled94119703pe_eled
peeler83517383pe_eler
peelers93615593pe_elers
peels75226423pe_el_s
peeries93623023peeries
peerless1037513peerless
pees65257373pe___es
peeves113814873pe_eves
peewees1236803peewees
pegboxes2043143pegboxes
pegless1038053pe_gless
peises84125043pe_ises
pekes114623563pe__kes
pekoes124410423pe_koes
pelages10714613pelages
pele65539553pe__le_
pelfs105016293pe__lfs
pelites93821993pelites
pellet83326553pe_llet
pellets94014783pe_llets
peltless10267373peltless
pelts76128813pe__lts
pelves114514663pe_lves
penates93321593penates
pencels113610053pencels
penes75839223pe__nes
penile82219603penile_
penises9318193penises
pennies94218813pennies
pensees9311203pensees
penults937123penults
peones83821043pe_ones
peonies93620153peonies
people10310183people_
peopled1238493peopled
peopler1138073peopler
peoplers1237153peoplers
peplos101211543pe_plos
peplus10138343pe_plus
percales12313803percales
perches143717953perches
perdues103511333perdues
peres76246643pe__res
periblem1445513periblem
periblems1543483periblems
periled10316313periled
perils84121853peril_s
perplex1836143perplex
perries93226603perries
perses85428063pe_rses
perukes133210113perukes
peruses94018163peruses
pesades10310903pesades
pestle83215843pestle_
pestled102711433pestled
petaled103614143petaled
petals84719813petal_s
petioles10311643petioles
petites93820203petites
petrales10312983petrales
petrels9279373petrels
pettle84116053pettle_
pettled103611503pettled
pewees11311393pe_wees
peyotes1238483peyotes
pibals103813083pibal_s
pickles153215443pickles
piddles114314273piddles
piebalds1344343piebalds
pieholes13168913pieholes
piffles15368763piffles
piles74742613p__iles
pilules9510623pilules
pimples133012423pimples
pinoles93418703pinoles
pintles94118723pintles
pizzles17329273pizzles
plebes104313623pleb_es
poles75351003p__oles
poodles103013513poodles
popples103011873popples
posoles9314883posoles
potables12179703potables
pottles93816983pottles
pozoles1839063pozoles
preambles1545333preambles
prebakes1639013prebakes
prebills1237293prebills
prebless1236823prebless
prefiles133113443prefiles
presales10315263presales
probables1545433probables
probes104119453prob_es
problem1335983problem
problems1434343problems
proles84627203p_roles
pubes94423403p_ub_es
puddles113613823puddles
pueblos1134843pueblos
pules74538813p__ules
pungles104013713pungles
purfles122511843purfles
purples112712823purples
puzzles17318973puzzles
quibbles2134223quibbles
rabbies113416053rabbies
rabble103818243rabble_
rabbled123514423rabbled
rabbler113514093rabbler
rabblers123810853rabblers
rambles113118313rambles
reales64934123re_ales
rebates95123183rebates
rebbe9313163rebb_e_
rebels84518133rebel_s
rebills93510623rebills
rebores95319163rebores
rebukes134210553rebukes
rebuses94915293rebuses
reddles93315773reddles
refiles104122423refiles
regales83520793regales
resales74724903resales
resiles74026543resiles
resoles73823653resoles
retables101712673retables
retiles74426993retiles
reviles104421353reviles
robles85321693_robles
roubles93413513roubles
rubbies114114113rubbies
rubble104315673rubble_
rubbled124611623rubbled
rubles83921703_rubles
rumbles114018393rumbles
sables85026693_sables
scabbles14167983scabbles
selles64426983se_lles
seniles72618023seniles
settles73916003settles
speckles16268133speckles
stables93219073stables
stubbles1236843stubbles
tabbies112913503tabbies
tables84524883_tables
teazles16308923teazles
teles54536003te__les
temples112610893temples
trebles9311443trebles
trembles1237353trembles
tubules9310233tubules
tumbles113816023tumbles
umbles103817493_umbles
unbales92914863unbales
venules104011483venules
verbiles1338923verbiles
verbless1336033verbless
wabble133714843wabble_
wabbled153311443wabbled
wabbler143511923wabbler
wabblers15398993wabblers
wambles143714023wambles
warbles123215563warbles
webbed1436433webb_ed
webbier1445423webbier
webbiest1535353webbiest
webless1237003we_bless
wimbles143010853wimbles
wobble133212313wobble_
wobbled15349593wobbled
wobbler14329823wobbler
wobblers15327883wobblers
wobblies15297233wobblies
yabbies14279643yabbies
yobboes1445583yobboes

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340273906.61020276.4
3Display Results3903900.1402785.7
 (SQL Overall)1786913906.89025934.8
 
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.