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

249 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
pebbly154508(None) 
pebble1238001pebble
bubbly124110352bubbly
feebly1436652feebly
hubbly16478412hubbly
nebuly1135792nebuly
nubbly13369672nubbly
pearly116414842pearly
pebbled1445392pebbled
pebbles1337572pebbles
pertly115312542pertly
rubbly133710612rubbly
wabbly16348362wabbly
webby1537142webb_y
wobbly16347092wobbly
abbey125714933_abbey
ably99725133__ably
aerily93017013aerily
apetaly1237253apetaly
babble94017113babble
belly104625493be_lly
blebby1233743blebb_y
bobble94115143bobble
bobby114814653bobb_y
bubble94016593bubble
bubby115013923bubb_y
burbly134311153burbly
cabby145314553cabb_y
cobble123615263cobble
cobby145516403cobb_y
cubby145212113cubb_y
dabble114515193dabble
deadly113811473deadly
deafly13389123deafly
dearly104615323dearly
deeply1257013deeply
deftly1336533deftly
delly96023873de_lly
derby114715343derb_y
dewily1338343dewily
dibble114013843dibble
dobby136013623dobb_y
doubly12328963doubly
drably123511613drably
dribbly15274953dribbly
dumbly14399603dumbly
early85324123_early
ebb72418623_ebb__
ebbed104111003_ebbed
ebbet93517293_ebbet
ebbs82411983_ebb_s
ebony104511513_ebony
eely77725213_e_ely
eerily92913563eerily
embay123410593_embay
emboly1336713emboly
epiboly1454353epiboly
featly123711753featly
feckly18335963feckly
feeble1138253feeble
felly114922803fe_lly
ferly115517353fe_rly
feyly14429513fe_yly
gabble113815723gabble
gabby135512943gabb_y
gently103710913gently
glibly1236293glibly
gobble113512983gobble
herby134715313herb_y
hobble133913433hobble
hobby155913723hobb_y
hubby155011393hubb_y
humbly164010523humbly
jebel145612143jebel_
jebels15418913jebels
jelly154218253je_lly
kebbie1435803kebbie
keenly1336373keenly
kelly124617023ke_lly
kibble143910953kibble
knobbly1842873knobbly
leally94012613leally
leanly93811503leanly
legibly1344623legibly
lewdly1334393lewdly
lobby125113913lobb_y
marbly134111933marbly
mealy104422183me_aly
meanly115412043meanly
measly113610443measly
medfly1535223medfly
meekly1535193meekly
meetly1138673meetly
merely111312583merely
mumbly15319463mumbly
nearly94813733nearly
neatly93812483neatly
nebula857333nebula
nebule848753nebule
nelly84618813ne_lly
nettly9459453nettly
newly114610203ne_wly
nibble103713283nibble
nimbly13388763nimbly
nobbily1436693nobbily
nobble103814313nobble
nobby125513453nobb_y
nobly105314403_nobly
nubble103813713nubble
nubby125011023nubb_y
numbly134410663numbly
openly1137123ope_nly
operably1557093operably
packly17228333packly
palely11311923palely
pally105727123p_ally
paly95835533p__aly
partly116315473partly
patly105020583p_atly
payably17177093payably
peachy164510843peachy
peaky145718153pe_aky
peal68648103pe_al_
peals75235493pe_als
pearl75324463pearl_
pearls84715383pearls
peartly1267453peartly
peaty105725693pe_aty
peavey14398793peavey
peavy135014843pe_avy
pebblier1453263pebblier
pebbling1535073pebbling
pecky165515093pe_cky
pedal86022503pedal_
pedalo93811143pedalo
pedals94316033pedals
peddle103512823peddle
peel65535613pe_el_
peels75226423pe_els
peery105719443pe_ery
pegbox1844013pegbox
pele65539553pe__le
pelf97031453pe__lf
pelt67651083pe__lt
peltry11288653peltry
penal75228373penal_
penally121111763penally
penalty1267743penalty
penile82219603penile
penny105119453pe_nny
pentyl1138813pentyl
penult8314653penult
penury1148103penury
peony105717563pe_ony
people10310183people
pepla9312863pe_pla
peppily1335123peppily
peppy114310363pe_ppy
perdy115417323pe_rdy
peril75425953peril_
perils84121853perils
perkily1637803perkily
perky145319483pe_rky
peroxy1838243peroxy
perry105222713pe_rry
peskily1635083peskily
pesky145911563pe_sky
pestle83215843pestle
pesty106421713pe_sty
petal76526893petal_
petals84719813petals
pettily1238173pettily
pettle84116053pettle
petty105320293pe_tty
pibal95217323pibal_
pibals103813083pibals
piddly13319143piddly
piebald1245503piebald
pily96132733p__ily
pimply15329213pimply
pinkly155012243pinkly
pliably14147383pliably
ply86323553p___ly
poboy121612223p_oboy
pokily15309063pokily
poly96235153p__oly
poorly1137893poorly
portly114713403portly
poshly1437723poshly
potboy1397813potboy
prebill1138803prebill
prebuy1357423prebuy
primly13439623primly
probably1746413probably
puddly13438133puddly
pueblo1035553pueblo
punily11311773punily
purely114013613purely
purply13369043purply
pussly11407373pussly
rabble103818243rabble
really93315613really
rebbe9313153rebb_e
rebbes10313533rebbes
rebel73421293rebel_
rebels84518133rebels
rebill84713243rebill
rebody1238153rebody
rebury11349213rebury
rebuy104714683re_buy
redbay1238333redbay
redly94217193re_dly
refly113914563re_fly
rely75428953re__ly
reply104015853re_ply
ribby12419673ribb_y
rubble104315673rubble
rubby124413853rubb_y
rumbly134412163rumbly
seely84522633se_ely
seemly1138433seemly
sexily1638853sexily
stably113314123stably
stubbly1444473stubbly
suably112814533suably
subtly11249263subtly
superbly1546973superbly
tabby125213883tabb_y
telly84920823te_lly
tenably122210453tenably
termly1138433termly
trebly1138973trebly
trembly1435523trembly
tubby124511393tubb_y
usably11288983usably
useably1287393useably
vealy115817773ve_aly
verily122616053verily
viably14199833viably
wabble133714843wabble
wambly16388663wambly
weakly1636483weakly
webbed1436433webbed
weekly1635313weekly
welly114620013we_lly
wetly114511713we_tly
wobble133212313wobble
yabby15389743yabb_y
yearly125210273yearly

Search took 6 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.1561145455.1
2DLD Change Limit1127162495.00022543.2
3Display Results2492490.0763276.3
 (SQL Overall)1786912495.23234153.5
 
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.