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

265 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
beatable12161224(None) 
bearable121512361bearable
boatable121610261boatable
eatable91717601_eatable
heatable131612041heatable
abatable1238022abatable
bearably15177932bearably
beddable14166922beddable
bendable131510852bendable
bitable11312202b_itable
blamable1436692blamable
bootable12179222bootable
breakable1746162breakable
breathable1744142breathable
cheatable1646712cheatable
creatable1339562creatable
datable101714232_datable
debatable1446312debatable
eatables10169792_eatables
getable101712552ge_table
getatable1235952getatable
gettable11178132gettable
hatable121713962_hatable
healable131610172healable
hearable131611602hearable
leasable101510132leasable
meltable12310472meltable
nestable101613672nestable
nettable101610242nettable
pettable121710712pettable
ratable91717552_ratable
readable11313162readable
reapable12311392reapable
relatable11310052relatable
rentable101716332rentable
restable101618432restable
retable91820402re_table
sealable101512692sealable
statable10310702statable
tearable101512672tearable
teasable101511172teasable
testable101412622testable
treatable1139322treatable
unbeatable1447832unbeatable
uneatable11311692uneatable
wearable131510552wearable
wettable13148042wettable
abradable1495063abradable
actable11313473_actable
adaptable1444613adaptable
agitable1138583agitable
arable81821003__arable
avertable14117343avertable
babble94017113b_a_bble
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
battle85217863b_at_tle
bauble103813213b_a_uble
beadle93314683be__adle
beagle93612593be__agle
beanball1264673beanball
beanpole1244333beanpole
bedabble1243703bedabble
beetle8311673beet__le
bejumble2172773bejumble
betaine9413783be_taine
betake124512703be_ta_ke
biddable14165673biddable
billable12179503billable
bindable13169623bindable
biteable1237933biteable
blamably1744903blamably
blameable1544723blameable
bleachable1943383bleachable
boardable1444893boardable
boilable1237793boilable
bombable1336263bombable
bondable13169273bondable
bookable16127003bookable
brabble10349973bra_bble
bramble133710033bra_mble
brattle9249253brat_tle
breakables1842753breakables
bribable1137223bribable
buffable1844393buffable
burnable1237263burnable
buyable1437493b_uyable
capable13313363_capable
cartable121314093cartable
castable121613973castable
chantable1636893chantable
chartable1636833chartable
chelatable1743603chelatable
citable11313463_citable
cleanable1345203cleanable
clearable1346013clearable
cleavable1644473cleavable
cuttable1247953cuttable
dateable1149443_dateable
debatably1754213debatably
decayable1745623decayable
delayable1546063delayable
deletable12149503deletable
deniable11312083deniable
denotable1238373denotable
deputable1487033deputable
dilatable1246853dilatable
draftable1575563draftable
drapable1377573drapable
drawable1467113drawable
editable11310423editable
effable15106673_effable
ejectable20136573ejectable
electable13149623electable
enable83318483_e_nable
enactable1338493enactable
equable1849253_equable
equatable2045193equatable
erasable10511043erasable
erectable131210093erectable
errable9312183_errable
evadable1436363evadable
evitable1339323evitable
exactable2046433exactable
eyeable1239063_eyeable
fadable13310463_fadable
feasible1376093feasible
feedable1437673feedable
fellable13179133fellable
fittable1337083fittable
floatable1444983floatable
foamable1537043foamable
framable1537573framable
gelable101710733ge_lable
giftable1465893giftable
gleanable1244083gleanable
gnawable1435683gnawable
gradable1238823gradable
grantable1257293grantable
grazable2036223grazable
gustable11138203gustable
hateable1339373_hateable
helpable1536603helpable
heritable1439453heritable
hewable15177823he_wable
hittable1336843hittable
huntable1338093huntable
imitable1239123imitable
inarable10313123inarable
instable10313193instable
keepable1635323keepable
kneadable1645673kneadable
leachable16136443leachable
learnable1145563learnable
lendable11169463lendable
leviable1337513leviable
liftable1376863liftable
listable10810303listable
loanable1037613loanable
locatable1345573locatable
makable15510203_makable
meatal84114733meata_l_
meatball1244513meatball
mendable131510583mendable
metastable1444923metastable
mutable11312303_mutable
namable11312333_namable
notable92114903_notable
obeyable1544113obe_yable
palatable1346373palatable
parable111819773_parable
payable141711323_payable
peaceable1548243peaceable
peccable1648103peccable
peelable1238553peelable
pentacle1239383pentacle
placable14169243placable
plantable1337273plantable
playable15137923playable
pleadable1445513pleadable
portable12313203portable
potable112115363_potable
quotable1936493quotable
ratables10159723_ratables
ratably121711513_ratably
rateable10311443_rateable
reachable16129653reachable
readably1438383readably
reefable1339533reefable
reelable10311593reelable
refutable1477863refutable
relaxable1836363relaxable
reliable10313073reliable
reparable1359953reparable
repayable1666343repayable
repeatable1447603repeatable
reputable1379123reputable
resalable1138733resalable
restabled12148943restabled
restables111511423restables
retables101712673re_tables
reusable10811273reusable
rotatable1146653rotatable
rustable101511353rustable
salable91415463_salable
satiable10310733_satiable
savable121711863_savable
sayable121411613_sayable
scalable121710233scalable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
separable1348673separable
servable13310083servable
sewable121911173se_wable
shakable17177683shakable
shamable15168793shamable
shapable15197803shapable
sharable131910693sharable
shavable16177273shavable
slakable14177553slakable
slayable13157563slayable
sortable10312483sortable
sparable121611973sparable
speakable1745373speakable
stable83921643__stable
stateable1136903stateable
stealable1136573stealable
suitable10310893suitable
swayable16135533swayable
table75429603___table
takable13310193_takable
tamable11312843_tamable
tastable101511973tastable
taxable1639073_taxable
teachable16137603teachable
tellable10169773tellable
temptable1545813temptable
tenable93214493te_nable
tenantable1244183tenantable
tentacle1037693tentacle
tiltable10159013tiltable
totable92313363_totable
tractable1338513tractable
tradable1139873tradable
unactable13310053unactable
unbearable1447383unbearable
unbeatably1745363unbeatably
undatable1238983undatable
unstable10313763unstable
vacatable1644643vacatable
vegetable1545683vegetable
vendable14159693vendable
veritable1448743veritable
votable122111373_votable
wadable13310233_wadable
wastable131410453wastable
waxable1937673_waxable
wearables14155003wearables
weldable1436863weldable
writable1338753writable

Search took 10 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 Filter1786911461620.1701051123.5
2DLD Change Limit1461622659.00316234.8
3Display Results2652650.1531732.0
 (SQL Overall)1786912659.32619160.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.