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

185 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
gettable1117813(None) 
getable101712551ge_table
getatable1235951getatable
nettable101610241nettable
pettable121710711pettable
wettable13148041wettable
beatable121612242beatable
cuttable1247952cuttable
eatable91717602_eatable
fittable1337092fittable
gelable101710732ge_lable
giftable1465892giftable
gustable11138202gustable
heatable131612042heatable
hittable1336852hittable
meltable12310472meltable
nestable101613672nestable
rentable101716332rentable
restable101618442restable
retable91820402re_table
testable101412622testable
abatable1238023abatable
actable11313473_actable
agitable1138583agitable
avertable14117343avertable
bearable121512363bearable
beddable14166923beddable
bendable131510853bendable
bitable11312203_bitable
biteable1237933biteable
boatable121610263boatable
bootable12179223bootable
cartable121314093cartable
castable121613973castable
cheatable1646713cheatable
citable11313463_citable
citeable1238413citeable
creatable1339563creatable
datable101714233_datable
dateable1149443dateable
debatable1446313debatable
deletable12149503deletable
deniable11312083deniable
denotable1238373denotable
deputable1487043deputable
detectable15136603detectable
detestable13136503detestable
detonable1247623detonable
dutiable1137373dutiable
eatables10169793_eatables
editable11310423editable
effable15106673_effable
ejectable20136573ejectable
electable13149623electable
enable83318483_e_nable
equable1849253_equable
erectable131210093erectable
errable9312183_errable
evitable1339323evitable
eyeable1239063_eyeable
feedable1437673feedable
fellable13179133fellable
fettle93713123fett__le
forgettable1752103forgettable
gable85325523g___able
gainable1138933gainable
generable1238663generable
gentile83515293gent_ile
gentle74014513gent__le
gestalt8411163gesta_lt
gestate83614073gesta_te
giftables1572593giftables
giveable14155753giveable
gleanable1244083gleanable
gnawable1435683gnawable
gradable1238823gradable
grantable1257293grantable
grazable2036223grazable
growable1435623growable
guessable1243733guessable
guidable1236203guidable
gullable1136463gullable
gustables12165223gustables
guttae73210583gutta__e
guttate8328903gutta_te
guttle74111973gutt__le
hatable121713963_hatable
hateable1339373hateable
healable131610173healable
hearable131611603hearable
helpable1536603helpable
heritable1439453heritable
hewable15177823he_wable
huntable1338093huntable
ignitable1245463ignitable
imitable1239123imitable
instable10313203instable
keepable1635323keepable
kettle104311613kett__le
knittable1544243knittable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liftable1376863liftable
listable10810313listable
mendable131510583mendable
metastable1444923metastable
mettle83815723mett__le
mutable11312303_mutable
nettle64514583nett__le
notable92114903_notable
outfable1378813outfable
peccable1648123peccable
peelable1238553peelable
pentacle1239383pentacle
petrale9312623petra_le
pettle84116053pett__le
pitiable1238293pitiable
portable12313203portable
potable112115363_potable
quotable1936493quotable
ratable91717553_ratable
rateable10311443rateable
readable11313163readable
reapable12311393reapable
rebuttable1443953rebuttable
reefable1339533reefable
reelable10311593reelable
refutable1477863refutable
regrettable1452983regrettable
relatable11310053relatable
reliable10313073reliable
remittable1445743remittable
reputable1379123reputable
resettable1256513resettable
restabled12148953restabled
restables111511423restables
retables101712673re_tables
reusable10811273reusable
rotatable1146653rotatable
rustable101511363rustable
satiable10310733satiable
sealable101512693sealable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310093servable
settle63915663sett__le
settleable1242583settleable
sewable121911173se_wable
sortable10312483sortable
spottable1345343spottable
stable83921643__stable
statable10310703statable
stewable1337133stewable
suitable10310893suitable
table75429603___table
tastable101511973tastable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
temptable1545813temptable
tenable93214493te_nable
tentacle1037693tentacle
tiltable10159013tiltable
tithable1336853tithable
titrable1038963titrable
totable92313363_totable
toteable1048353toteable
treatable1139323treatable
uneatable11311693uneatable
unstable10313763unstable
vegetable1545683vegetable
vendable14159693vendable
veritable1448743veritable
vitiable1337503vitiable
votable122111373_votable
voteable1347213voteable
wastable131410453wastable
wearable131510553wearable
weldable1436863weldable
writable1338753writable
zettabyte235983zettabyte

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 Filter1786911461620.483369960.7
2DLD Change Limit1461621857.28020077.2
3Display Results1851850.0802312.5
 (SQL Overall)1786911857.84322783.5
 
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.