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

348 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
getable10171255(None) 
gelable101710731gelable
gettable11178131gettable
retable91820401retable
actable11313472actable
agitable1138582agitable
beatable121612242beatable
bitable11312202bitable
citable11313462citable
datable101714232datable
eatable91717602eatable
enable83318482_enable
gable85325522g__able
getatable1235952getatable
giftable1465892giftable
gustable11138202gustable
hatable121713962hatable
heatable131612042heatable
hewable15177822hewable
meltable12310472meltable
mutable11312302mutable
nestable101613672nestable
nettable101610242nettable
notable92114902notable
pettable121710712pettable
potable112115362potable
ratable91717552ratable
rentable101716332rentable
restable101618442restable
retables101712672retables
seeable91113942seeable
sewable121911172sewable
stable83921642_stable
table75429602__table
tenable93214492tenable
testable101412622testable
totable92313362totable
vegetable1545682vegetable
votable122111372votable
wettable13148042wettable
abatable1238023abatable
able66340533___able
addable11218843addable
affable15117403affable
agreeable1244653agreeable
amenable1238863amenable
amiable11312033amiable
arable81821003_arable
avertable14117343avertable
beadle93314683be_adle
beagle93612593be_agle
bearable121512363bearable
bedabble1243703bedabble
beddable14166923beddable
bendable131510853bendable
betaine9413783betaine
betake124512703beta_ke
biteable1237933biteable
boatable121610263boatable
bootable12179223bootable
buyable1437493buyable
cable95329913__cable
capable13313363capable
cartable121314093cartable
castable121613973castable
cenacle1139123cenacle
cetane8315283ceta_ne
cheatable1646713cheatable
chewable1835443chewable
citeable1238413citeable
codable12311663codable
cogitable1446943cogitable
covetable1648163covetable
creatable1339563creatable
curable112414513curable
cuttable1247953cuttable
dateable1149443dateable
debacle1237443debacle
debatable1446313debatable
deletable12149503deletable
deniable11312083deniable
denotable1238373denotable
deputable1487043deputable
detail74516433detail_
detailed10319873detailed
detailer9268673detailer
details84214043details
detonable1247623detonable
disable10516433disable
doable93115243_doable
dowable13189453dowable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dutiable1137373dutiable
dyable12308983_dyable
dyeable1337303dyeable
eagle64219483_e_agle
eatables10169793eatables
edible969353_edible
editable11310423editable
effable15106673effable
ejectable20136573ejectable
electable13149623electable
enabled102510633_enabled
enabler9299363_enabler
enables92813123_enables
equable1849253equable
erectable131210093erectable
errable9312183errable
etape74413703_eta_pe
etoile6312263_etoile
evitable1339323evitable
eyeable1239063eyeable
fable105824753__fable
fadable13310463fadable
feeble1138253fe_eble
feedable1437673feedable
fellable13179133fellable
female11310553fema_le
fenagle11197153fenagle
fetal85623373feta_l_
fettle93713123fet_tle
fightable1844373fightable
finable122213623finable
fittable1337093fittable
fixable19218193fixable
flyable15307123flyable
friable122612563friable
fryable15277463fryable
gabble113815723g_abble
gabled105518453g__abled
gables94222333g__ables
gainable1138933gainable
gale56347323g__a_le
gamble115417183g_amble
garble94118453g_arble
gelate73421253gela_te
gemmule12173233gemmule
generable1238663generable
gentile83515293gentile
gentle74014513ge_ntle
gestalt8411163gesta_lt
gestate83614073gesta_te
geta56627443geta___
getas65421483geta__s
getaway1444013getaway
giftables1572593giftables
giveable14155753giveable
gleanable1244083gleanable
gnawable1435683gnawable
gobble113512983g_obble
grabble12339643grabble
gradable1238823gradable
grantable1257293grantable
grazable2036223grazable
gribble12297273gribble
growable1435623growable
grumble12349233grumble
guessable1243733guessable
guidable1236203guidable
gullable1136463gullable
gustables12165223gustables
guttle74111973gut_tle
hateable1339373hateable
healable131610173healable
hearable131611603hearable
helpable1536603helpable
heritable1439453heritable
hidable1399403hidable
hirable121612313hirable
hittable1336853hittable
huntable1338093huntable
ignitable1245463ignitable
imitable1239123imitable
instable10313203instable
keepable1635323keepable
kettle104311613ket_tle
leasable101510133leasable
legible1035833legible
lendable11169463lendable
leviable1337513leviable
liable81415813_liable
lienable10188693lienable
liftable1376863liftable
likable13219413likable
linable92214343linable
listable10810313listable
livable122010323livable
losable91910953losable
lovable12179553lovable
makable15510203makable
measle83513223me_asle
mendable131510583mendable
metage93114453meta_ge
metal75427383meta_l_
metaled102913883meta_led
metalled1148983metalled
metals84520883meta_ls
metate82720533meta_te
mettle83815723met_tle
minable112315073minable
mixable18259173mixable
movable14189433movable
mutably1438613mutably
namable11312343namable
nettle64514583net_tle
notables10178243notables
notably12199993notably
obeyable1544113obeyable
openable1247013openable
operable12410323operable
outfable1378813outfable
overable13513573overable
ownable1237283ownable
parable111819773parable
payable141711323payable
pebble1238003pe_bble
peccable1648123peccable
peelable1238553peelable
pentacle1239383pentacle
petabyte1542783petabyte
petal76526893peta_l_
petaled103614153peta_led
petalled1138703petalled
petals84719813peta_ls
petiole9311303petiole
petrale9312623petrale
pettle84116053pet_tle
pitiable1238293pitiable
pliable111610323pliable
pokable15209503pokable
portable12313203portable
posable112212783posable
potables12179703potables
quotable1936493quotable
ratables10159723ratables
ratably121711513ratably
rateable10311443rateable
readable11313163readable
reapable12311393reapable
reefable1339533reefable
reelable10311593reelable
refutable1477863refutable
regale74821453rega_le
relabel938163relabel
relatable11310053relatable
reliable10313073reliable
reputable1379123reputable
resale64025543resa_le
restabled12148953restabled
restables111511423restables
retackle1445043retackle
retail65522073retail_
retailed94113963retailed
retailer82911573retailer
retails74718973retails
retake104718533reta_ke
retally10413683retally
retape83917683reta_pe
retaste72313133retaste
reticle94112623reticle
retile65929673ret_ile
retitle73913093retitle
reusable10811273reusable
ridable101412493ridable
ropable111611333ropable
rowable121510303rowable
rulable9310533rulable
rustable101511363rustable
sable74732163__sable
salable91415463salable
satiable10310733satiable
savable121711863savable
sayable121411613sayable
sealable101512693sealable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310083servable
setae56026223seta__e
setal56430903seta_l_
settle63915663set_tle
shedable1437423shedable
sizable1839893sizable
skiable1338883skiable
sortable10312483sortable
sowable121610753sowable
stabile9312063_stabile
stabled103514953_stabled
stabler94014933_stabler
stables93219073_stables
stably113314123_stably
stale55637103_sta_le
staple84415823_staple
statable10310703statable
stewable1337133stewable
suable83920553_suable
suitable10310893suitable
tabla73318363__tabla
tabled94020043__tabled
tables84524893__tables
tablet84227643__tablet
takable13310193takable
tale46154163__ta_le
tamable11312853tamable
targetable1383873targetable
tastable101511973tastable
taxable1639073taxable
tearable101512673tearable
teasable101511173teasable
teazle15329553te_azle
tellable10169773tellable
temptable1545813temptable
tenably122210453tenably
tentacle1037693tentacle
tiltable10159013tiltable
timetable1346873timetable
tithable1336853tithable
titrable1038963titrable
toteable1048353toteable
towable121910113towable
treatable1139323treatable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
uneatable11311693uneatable
unstable10313763unstable
usable84012553_usable
useable9911063useable
vegetables1642703vegetables
vegetably1843953vegetably
vendable14159693vendable
veritable1448743veritable
viable111613773_viable
viewable1635223viewable
vitiable1337503vitiable
vocable14189673vocable
voteable1347213voteable
wadable13310233wadable
wastable131410453wastable
waxable1937673waxable
wearable131510553wearable
weldable1436863weldable
wirable121610963wirable
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.420425454.8
2DLD Change Limit1340273486.75019855.9
3Display Results3483480.1262761.9
 (SQL Overall)1786913487.29624491.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.