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

247 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
boatable12161026(None) 
beatable121612241beatable
bootable12179221bootable
abatable1238022abatable
bearable121512362bearable
bitable11312202b_itable
blamable1436692blamable
boardable1444892boardable
boilable1237792boilable
bombable1336262bombable
bondable13169272bondable
bookable16127002bookable
datable101714232_datable
eatable91717602_eatable
floatable1444982floatable
foamable1537042foamable
hatable121713962_hatable
heatable131612042heatable
loanable1037612loanable
locatable1345572locatable
notable92114902no_table
portable12313202portable
potable112115362po_table
ratable91717552_ratable
rotatable1146652rotatable
sortable10312482sortable
statable10310702statable
totable92313362to_table
votable122111372vo_table
abradable1495063abradable
actable11313473_actable
adaptable1444613adaptable
adoptable1444753adoptable
agitable1138583agitable
arable81821003__arable
babble94017113b_a_bble
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249253barrable
battle85217863b_at_tle
bauble103813213b_a_uble
bearably15177933bearably
beddable14166923beddable
bendable131510853bendable
biddable14165673biddable
billable12179503billable
bindable13169623bindable
biteable1237933biteable
blamably1744903blamably
blameable1544723blameable
blockable1944303blockable
boatbill1244463boatbill
boatel84314093boat_el_
boatels93510233boat_els
boatful1236283boatful_
boatfuls1344823boatfuls
boatlike1457963boatlike
bobble94115143bo__bble
bobtail1146553bobtail_
bobtailed1443193bobtailed
bobtails1245193bobtails
bolthole1345463bolthole
bottle84916073bo_t_tle
boundable1444843boundable
brabble10349973bra_bble
bramble133710033bra_mble
brattle9249253brat_tle
breakable1746163breakable
breathable1744143breathable
bribable1137223bribable
browsable1643863browsable
buffable1844393buffable
burnable1237263burnable
buyable1437493b_uyable
capable13313363_capable
cartable121314093cartable
castable121613973castable
chantable1636893chantable
chartable1636833chartable
cheatable1646713cheatable
citable11313463_citable
coachable1846303coachable
codable12311663co_dable
cogitable1446943cogitable
coinable12311583coinable
constable13311003constable
cookable16147973cookable
copyable1736623copyable
countable1348853countable
covetable1648163covetable
creatable1339563creatable
cuttable1247953cuttable
dateable1149443_dateable
debatable1446313debatable
dilatable1246853dilatable
doable93115243do__able
doubtable1445163doubtable
dowable13189453do_wable
draftable1575563draftable
drapable1377573drapable
drawable1467113drawable
eatables10169793_eatables
editable11310423editable
enactable1338493enactable
equatable2045193equatable
erasable10511043erasable
evadable1436363evadable
evitable1339323evitable
exactable2046433exactable
fadable13310463_fadable
fittable1337093fittable
foilable1338063foilable
foldable1437133foldable
fordable1439593fordable
formable1539503formable
framable1537573framable
getable101712553_getable
getatable1235953getatable
gettable11178133gettable
giftable1465893giftable
gnawable1435683gnawable
gradable1238823gradable
grantable1257293grantable
grazable2036223grazable
gustable11138203gustable
hateable1339373_hateable
healable131610183healable
hearable131611613hearable
hittable1336853hittable
holdable1437073holdable
huntable1338093huntable
imitable1239123imitable
inarable10313133inarable
instable10313203instable
isolatable1244373isolatable
joinable1737283joinable
leasable101510133leasable
liftable1376863liftable
listable10810313listable
lockable1636953lockable
losable91910953lo_sable
lovable12179553lo_vable
loveable13187903loveable
makable15510203_makable
meltable12310473meltable
mockable1846643mockable
moldable1337103moldable
mountable1346303mountable
movable14189433mo_vable
moveable15168013moveable
mutable11312303_mutable
namable11312343_namable
nestable101613673nestable
nettable101610243nettable
nonarable1149053nonarable
notables10178243no_tables
notably12199993no_tably
obeyable1544113obeyable
obstacle1243593obstacle
obviable1543863obviable
outfable1378813_outfable
ownable1237283_ownable
palatable1346383palatable
parable111819783_parable
payable141711323_payable
pettable121710713pettable
placable14169243placable
plantable1337273plantable
playable15137923playable
poachable1846243poachable
pointable1337343pointable
pokable15209503po_kable
portables1337873portables
portably1539313portably
posable112212783po_sable
potables12179703po_tables
pourable1239133pourable
quotable1936493quotable
ratables10159723_ratables
ratably121711513_ratably
rateable10311443_rateable
readable11313163readable
reapable12311393reapable
relatable11310053relatable
rentable101716333rentable
restable101618443restable
retable91820403_retable
rockable1638013rockable
ropable111611333ro_pable
rowable121510303ro_wable
rustable101511363rustable
salable91415463_salable
satiable10310733_satiable
savable121711863_savable
sayable121411613_sayable
scalable121710233scalable
sealable101512693sealable
shakable17177683shakable
shamable15168803shamable
shapable15197803shapable
sharable131910693sharable
shavable16177273shavable
slakable14177553slakable
slayable13157563slayable
sociable1239503sociable
solvable1337473solvable
sorbable1239303sorbable
sortably1338803sortably
sowable121610753so_wable
sparable121611983sparable
spottable1345343spottable
stable83921643__stable
stateable1136903stateable
suitable10310893suitable
swayable16135533swayable
table75429603___table
takable13310193_takable
tamable11312853_tamable
tastable101511973tastable
taxable1639073_taxable
tearable101512673tearable
teasable101511173teasable
testable101412623testable
tiltable10159013tiltable
toteable1048353toteable
towable121910113to_wable
tractable1338513tractable
tradable1139873tradable
treatable1139323treatable
unactable13310053unactable
unbeatable1447833unbeatable
undatable1238983undatable
uneatable11311693uneatable
unstable10313763unstable
vacatable1644643vacatable
vocable14189673vo_cable
voidable1466853voidable
voteable1347213voteable
wadable13310233_wadable
wastable131410453wastable
waxable1937673_waxable
wearable131510563wearable
wettable13148043wettable
workable1737093workable
worktable1844723worktable
writable1338753writable

Search took 9 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.406440125.6
2DLD Change Limit1461622477.62319173.8
3Display Results2472470.1102245.5
 (SQL Overall)1786912478.13921954.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.