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

360 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
wabbly1634836(None) 
wabble133714841wabble
wambly16388661wambly
wobbly16347091wobbly
abbey125714932_abbey
ably99725132_a_bly
babble94017112babble
bubbly124110352bubbly
cabby145314552cabb_y
dabble114515192dabble
gabble113815722gabble
gabby135512942gabb_y
hubbly16478412hubbly
marbly134111932marbly
nubbly13369672nubbly
pebbly1545082pebbly
rabble103818242rabble
rubbly133710612rubbly
swabby1634352swabb_y
tabby125213882tabb_y
wabbled153311442wabbled
wabbler143511922wabbler
wabbles144013992wabbles
waddly14478722waddly
waffly18305432waffly
waggly14347292waggly
wally114625092wa_lly
waly105830902wa__ly
wamble134415752wamble
wanly115118022wa_nly
warble113516602warble
warily122915092warily
warmly14228062warmly
wavily15219482wavily
waxily19218412waxily
webby1537142webb_y
wobble133212312wobble
yabby15389742yabb_y
abba810522643_abb_a
abbacy1536623_abbacy
abbas95918643_abbas
abbe87627183_abb_e
abbes96723523_abbes
abbeys13538423_abbeys
abbot9318453_abbot
abele76323253_abele
able66340533_a_ble
aby810238063_a_b_y
agly86821803_a_gly
ally76935643_a_lly
amble95924633_amble
ambry123512093_ambry
amply125012913_amply
apply125111393_apply
aptly105111813_aptly
babbled113612863babbled
babbler104012823babbler
babbles104416323babbles
babel95821693babel_
babels105216723babels
babul96317713babul_
babuls105413643babuls
baby116723673ba_b_y
badly114918763ba_dly
baldly12479833baldly
bally105530103ba_lly
barely114716793barely
barfly14339653barfly
basely114412313basely
bassly114610073bassly
batboy1387533batboy
bauble103813213bauble
blabby1234813blabb_y
bobble94115143bobble
bobby114814653bobb_y
brabble10349973brabble
brambly16296253brambly
bubble94016593bubble
bubby115013923bubb_y
burbly134311153burbly
cabal95222153cabal_
cabala103516913cabala
cabals104020153cabals
cabbagy1744013cabbagy
cabbala1367183cabbala
cabbed135416263cabbed
cabbie122913343cabbie
cable95329913ca_ble
cagily12411563cagily
calmly1337613calmly
capably1639253capably
carboy134914183carboy
cobble123615263cobble
cobby145516403cobb_y
crabbily1744343crabbily
crabby15346753crabb_y
cubby145212113cubb_y
dabbed124416143dabbed
dabber114816963dabber
dabbled133712073dabbled
dabbler124012153dabbler
dabbles124514773dabbles
daftly1335443daftly
daily95922333da_ily
dally95324743da_lly
damply14337893damply
dangly114212263dangly
dankly14419463dankly
darkly145411073darkly
daubry12445483daubry
dauby115211223daub_y
dayfly1633813dayfly
dibble114013843dibble
dobby136013623dobb_y
doubly12328963doubly
drabble12238883drabble
drably123511613drably
dribbly15274953dribbly
dumbly14399603dumbly
early85324123ea_rly
easily9313023easily
emboly1336713emboly
fabber134814113fabber
fable105824753fa_ble
fairly125610013fairly
family143311703family
fatly115716803fa_tly
feebly1436653feebly
flabbily1843353flabbily
flabby1634573flabb_y
gabbed125216893gabbed
gabber114916603gabber
gabbled134112453gabbled
gabbler124013303gabbler
gabbles124415413gabbles
gabbro11114953gabbro
gable85325523ga_ble
gaby107123193ga_b_y
gadfly1434663gadfly
gaily95020973ga_ily
gainly1049323gainly
gally95026173ga_lly
gamble115417183gamble
gamely124711913gamely
gamily123712183gamily
gangly113911583gangly
garble94118453garble
gayly124513093ga_yly
glibly1236293glibly
gobble113512983gobble
grabble12339643grabble
grabby14336183grabb_y
habile11515203habile
hackly18298733hackly
haply135915063ha_ply
hardly135112833hardly
hazily2179063hazily
hobble133913433hobble
hobby155913723hobb_y
hubby155011393hubb_y
humbly164010523humbly
jabbed184213483jabbed
jabber173713643jabber
jangly174310603jangly
kabala124011553kabala
kabbala1584613kabbala
kibble143910953kibble
knobbly1842873knobbly
label75019383label_
labels84515683labels
labile8315213labile
lacily11612763lacily
lamby125114843lamb_y
lamely114013223lamely
lanely93914483lanely
lankly13439623lankly
lastly93310873lastly
lately93413843lately
laxly15610103la_xly
lazily1859713lazily
lobby125113913lobb_y
madly115218133ma_dly
mainly11411493mainly
manly105022943ma_nly
marble104219103marble
marly106925613ma_rly
mayfly1734403mayfly
mazily20610393mazily
mumbly15319463mumbly
nabbed115113613nabbed
nabber104913543nabber
namely113711323namely
nebuly1135793nebuly
nibble103713283nibble
nimbly13388763nimbly
nobbily1436693nobbily
nobble103814313nobble
nobby125513453nobb_y
nobly105314403_nobly
nubble103813713nubble
nubby125011023nubb_y
numbly134410663numbly
packly17228333packly
palely11311923palely
pally105727123pa_lly
paly95835533pa__ly
partly116315473partly
patly105020583pa_tly
payably17177093payably
pebble1238003pebble
qabala17399193qabala
rabbet103818653rabbet
rabbi93113173rabb_i
rabbin103112293rabbin
rabbis102613153rabbis
rabbit102914553rabbit
rabbity14266303rabbity
rabbled123514423rabbled
rabbler113514093rabbler
rabbles113517973rabbles
rabidly1336253rabidly
racily11715173racily
rally84725903ra_lly
rambla103510933rambla
ramble104519973ramble
rankly133910453rankly
raptly11338913raptly
rarely93513653rarely
rashly123410213rashly
ratably121711513ratably
rattly94111543rattly
rawly115115833ra_wly
ribby12419673ribb_y
rubble104315673rubble
rubby124413853rubb_y
rumbly134412163rumbly
sabal75422483sabal_
sabals84618863sabals
sabbat10314713sabbat
sabbed114518083sabbed
sable74732163sa_ble
sadly94519123sa_dly
safely12249393safely
sagely102811383sagely
salably121610743salably
sally85129713sa_lly
sanely93114613sanely
sawfly1535133sawfly
scabbily1763943scabbily
scabble13168653scabble
scabby1535503scabb_y
scrabbly17164623scrabbly
shabbily1873903shabbily
shabby1635803shabb_y
stably113314123stably
stubbly1444473stubbly
suably112814533suably
subtly11249263subtly
swabbed15367403swabbed
swabber14297963swabber
swabbie1484333swabbie
tabbed114215363tabbed
tabbis102910853tabbis
tabla73318363ta_bla
table75429603ta_ble
tabuli839363tabuli
tally84526863ta_lly
tamely113711953tamely
tangly104413913tangly
tartly96014023tartly
tautly9499503tautly
taxably1936043taxably
trebly1138973trebly
tubby124511393tubb_y
usably11288983usably
vainly1258503vainly
vastly12508723vastly
viably14199833viably
wab87051833wa_b__
wabblers15398993wabblers
wabblier15375493wabblier
wabbling16207743wabbling
wabs97337233wa_b_s
wackily1936053wackily
wacky174714933wa_cky
wadable13310233wadable
waddle114715303waddle
waddy135312993wa_ddy
wady115324993wa__dy
wafery15398693wafery
waffle15369183waffle
waggle113612303waggle
wail75238823wa_il_
wails86631483wa_ils
wale74546433wa__le
walk115625613wa__lk
wall76236103wa__ll
walla85321033wa_lla
walls85529383wa_lls
wambled153610753wambled
wambles143714023wambles
wandle105316663wandle
waney115120323wa_ney
wangle103817503wangle
wany106432353wa__ny
warbled133212163warbled
warbler123211463warbler
warbles123215563warbles
warsle93112923warsle
warty119323823wa_rty
wary106740013wa__ry
washy145911843wa_shy
waspily1535513waspily
waspy135410993wa_spy
wastry12388773wastry
watery123914493watery
wattle94314213wattle
waul76927313wa_ul_
wauls86120553wa_uls
wavery154610053wavery
wavey145115543wa_vey
wavy136620473wa__vy
wawl105321943wa_wl_
wawls115416473wa_wls
waxable1937673waxable
waxbill1943133waxbill
waxy175918203wa__xy
way96757663wa___y
waybill1543723waybill
waylay1535453waylay
weakly1636483weakly
wearily1338783wearily
weasely13317853weasely
webbed1436433webbed
weekly1635313weekly
welly114620013w_elly
wetly114511713w_etly
whirly15448863whirly
wholly15366573wholly
widely133311033widely
wifely15429423wifely
wiggly14559683wiggly
wildly13328123wildly
wilily123310763wilily
willy115321913w_illy
wily106428813w__ily
wimble133211913wimble
wirily123310783wirily
wisely122711713wisely
wobbled15349593wobbled
wobbler14329823wobbler
wobbles143412433wobbles
womby155910093womb_y
woolly12408513woolly
wooly114417673w_ooly
wryly14356703w_ryly
yabber136111833yabber
yabbie13308653yabbie
yarely122810303yarely
zanily18310183zanily

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 Limit1127163605.78319490.9
3Display Results3603600.1063396.2
 (SQL Overall)1786913606.01529707.6
 
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.