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

334 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
wadable1331023(None) 
fadable13310461fadable
wadeable1437441wadeable
waxable1937671waxable
addable11218842addable
arable81821002_arable
awardable1543952awardable
capable13313362capable
codable12311662codable
datable101714232datable
eatable91717602eatable
evadable1436362evadable
gradable1238822gradable
hatable121713962hatable
hidable1399402hidable
laudable1137892laudable
makable15510202makable
namable11312332namable
parable111819772parable
payable141711322payable
radiable11611302radiable
ratable91717552ratable
readable11313162readable
ridable101412492ridable
salable91415462salable
sandable111612822sandable
savable121711862savable
sayable121411612sayable
swayable16135532swayable
takable13310192takable
tamable11312842tamable
taxable1639072taxable
tradable1139872tradable
wabble133714842wa_bble
waddle114715302wad_dle
walkable1736062walkable
wamble134415752wa_mble
warble113516602wa_rble
washable16138042washable
wastable131410452wastable
wearable131510552wearable
weldable1436862weldable
windable14159152windable
wirable121610962wirable
abatable1238023abatable
able66340533___able
abradable1495063abradable
actable11313473actable
adage7414053_ada_ge
addible11236063addible
addle74318353_ad_dle
adobe84814703_adob_e
adorable1138773_adorable
affable15117403affable
alible8311973_alible
amble95924633_a_mble
amiable11312033amiable
arables91814973_arables
audible10228243audible
babble94017113ba_bble
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bauble103813213ba_uble
bearable121512363bearable
beatable121612243beatable
bedabble1243703bedabble
beddable14166923beddable
bendable131510853bendable
biddable14165673biddable
bindable13169623bindable
bitable11312203bitable
blamable1436693blamable
boardable1444893boardable
boatable121610263boatable
bondable13169273bondable
buyable1437493buyable
cable95329913__cable
cadelle1039913cadelle
callable12310753callable
capabler1435353capabler
capably1639253capably
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
citable11313463citable
curable112414513curable
dabble114515193da_bble
daddle94214283dad_dle
dale55643983__da_le
damnable1347593damnable
dateable1149443dateable
disable10516433disable
doable93115243_doable
dowable13189453dowable
drapable1377573drapable
drawable1467113drawable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyable12308983_dyable
dyeable1337303dyeable
eatables10169793eatables
edible969353_edible
effable15106673effable
enable83318483_enable
equable1849253equable
erasable10511043erasable
erodable1139203erodable
errable9312183errable
evadible1443963evadible
eyeable1239063eyeable
fable105824753__fable
faceable15108493faceable
farmable1538203farmable
feedable1437673feedable
finable122213623finable
findable14179023findable
fixable19218193fixable
flyable15307123flyable
foamable1537043foamable
foldable1437133foldable
fordable1439593fordable
framable1537573framable
friable122612563friable
fryable15277463fryable
gabble113815723ga_bble
gable85325523__gable
gainable1138933gainable
gamble115417183ga_mble
garble94118453ga_rble
gelable101710733gelable
getable101712553getable
gnawable1435683gnawable
grazable2036223grazable
guidable1236203guidable
hackable1937473hackable
hadal95518123hada_l_
hangable1438203hangable
hateable1339373hateable
healable131610173healable
hearable131611603hearable
heatable131612043heatable
hewable15177823hewable
hirable121612313hirable
holdable1437073holdable
inarable10313123inarable
jailable1737143jailable
jammable2144513jammable
kneadable1645673kneadable
ladle66320443lad__le
lapsable12117383lapsable
laudably1445123laudably
leasable101510133leasable
lendable11169463lendable
liable81415813_liable
likable13219413likable
linable92214343linable
livable122010323livable
loanable1037613loanable
losable91910953losable
lovable12179553lovable
macabre1335223macabre
madame1139853mada_me
mailable1239623mailable
makeable1637253makeable
manacle11310283manacle
mandible1337543mandible
mappable1635923mappable
marble104219103ma_rble
maskable1638003maskable
mendable131510583mendable
minable112315073minable
mixable18259173mixable
moldable1337103moldable
movable14189433movable
mutable11312303mutable
nameable1238863nameable
notable92114903notable
ownable1237283ownable
oxidable1865123oxidable
packable1838633packable
paddle104615143pad_dle
padle84522343pad__le
palpable1448033palpable
parables121613563parables
parsable12311693parsable
passable12310623passable
pawnable1535983pawnable
payables15166483payables
payably17177093payably
placable14169243placable
playable15137923playable
pleadable1445513pleadable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
rabble103818243ra_bble
raddle84816173rad_dle
radiale83813523radiale
radicle103510713radicle
raisable10311643raisable
ramble104519973ra_mble
ratables10159723ratables
ratably121711513ratably
rateable10311443rateable
readably1438383readably
reapable12311393reapable
retable91820403retable
rewardable1643883rewardable
rideable1158653rideable
ropable111611333ropable
rowable121510303rowable
rulable9310533rulable
sable74732163__sable
saddle83915493sad_dle
sailable10310563sailable
salably121610743salably
saleable10312023saleable
salvable1338403salvable
satiable10310733satiable
saveable1339003saveable
scalable121710233scalable
sealable101512693sealable
seeable91113943seeable
sendable111612043sendable
sewable121911173sewable
shakable17177683shakable
shamable15168793shamable
shapable15197803shapable
sharable131910693sharable
shavable16177273shavable
shedable1437423shedable
sizable1839893sizable
skiable1338883skiable
slakable14177553slakable
slayable13157563slayable
slidable1137953slidable
sowable121610753sowable
sparable121611973sparable
stable83921643_stable
statable10310703statable
suable83920553_suable
swaddle12276743swad_dle
table75429603__table
tadpole1036143tadpole
takeable1437463takeable
talkable1437193talkable
tamale83717393tama_le
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxables1734383taxables
taxably1936043taxably
tearable101512673tearable
teasable101511173teasable
tenable93214493tenable
totable92313363totable
towable121910113towable
tradeable1247413tradeable
triable92515393triable
tunable92511313tunable
twaddle12245713twad_dle
typable1435883typable
unable83819223_unable
undoable1139053undoable
usable84012553_usable
useable9911063useable
valuable1336863valuable
variable13310063variable
vendable14159693vendable
viable111613773_viable
vocable14189673vocable
voidable1466853voidable
votable122111373votable
wabbled153311443wa_bbled
wabbler143511923wa_bbler
wabbles144013993wa_bbles
wabbly16348363wa_bbly
waddie114013323wad_die
waddled133611643wad_dled
waddler124010793wad_dler
waddles124314843wad_dles
waddly14478723wad_dly
wade85237063wad___e
wadmaal1343203wadmaal_
wadmaals1442413wadmaals
wadmal1237283wadmal_
wadmals1335513wadmals
wadmel1235523wadmel_
wadmels1334303wadmels
wadmol1234053wadmol_
wadmoll1352903wadmoll
wadmols1333913wadmols
waffle15369183wa_ffle
waggle113612303wa_ggle
wakame1535433waka_me
wale74546433w__a_le
wambled153610753wa_mbled
wambles143714023wa_mbles
wambly16388663wa_mbly
wandle105316663wa_ndle
wangle103817503wa_ngle
wannabe1234533wannab_e
wannabee1343993wannabee
warbled133212163wa_rbled
warbler123211463wa_rbler
warbles123215563wa_rbles
warsle93112923wa_rsle
warstle10328013warstle
wasabi1154643wasab_i
wasabis1255363wasabis
washables17144743washables
watape11208483wata_pe
watchable1944773watchable
wattle94314213wa_ttle
wavicle1534063wavicle
wearables14155003wearables
wettable13148043wettable
whale115517433w_ha_le
widdle113814843wid_dle
wieldable1543813wieldable
willable13168683willable
wimble133211913w_imble
winnable13156983winnable
wobble133212313w_obble
workable1737093workable
writable1338753writable

Search took 8 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.1431249587.4
2DLD Change Limit1340273346.76619808.9
3Display Results3343340.1232715.4
 (SQL Overall)1786913347.03225411.1
 
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.