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

186 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
nettable10161024(None) 
gettable11178131gettable
nestable101613671nestable
pettable121710711pettable
wettable13148041wettable
beatable121612242beatable
cuttable1247952cuttable
eatable91717602_eatable
fittable1337092fittable
getable101712552ge_table
getatable1235952getatable
heatable131612042heatable
hittable1336852hittable
knittable1544242knittable
meltable12310472meltable
nettle64514582nett__le
notable92114902n_otable
rentable101716332rentable
restable101618442restable
retable91820402re_table
testable101412622testable
uneatable11311692uneatable
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
enactable1338493enactable
enterable11312643enterable
enviable1337853enviable
equable1849253_equable
erectable131210093erectable
errable9312183_errable
evitable1339323evitable
eyeable1239063_eyeable
feedable1437673feedable
fellable13179133fellable
fettle93713123fett__le
gelable101710733ge_lable
giftable1465893giftable
gustable11138203gustable
hatable121713963_hatable
hateable1339373hateable
healable131610173healable
hearable131611603hearable
helpable1536603helpable
heritable1439453heritable
hewable15177823he_wable
huntable1338093huntable
imitable1239123imitable
incitable13310433incitable
ineffable17105793ineffable
inerrable11410163inerrable
inevitable1557643inevitable
injectable2147003injectable
instable10313203instable
investable1548043investable
keepable1635323keepable
kettle104311613kett__le
kneadable1645673kneadable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liftable1376863liftable
listable10810313listable
mendable131510583mendable
metastable1444923metastable
mettle83815723mett__le
mutable11312303_mutable
namable11312343n_amable
nameable1238863nameable
negotiable1343973negotiable
nestle63013953nest__le
nettled8339943nett__led
nettler7349503nett__ler
nettles73214083nett__les
nettly9459453nett__ly
notables10178243n_otables
notably12199993n_otably
outfable1378813outfable
peccable1648123peccable
peelable1238553peelable
penetrable1446043penetrable
pentacle1239383pentacle
petrale9312623petra_le
pettle84116053pett__le
pitiable1238293pitiable
portable12313203portable
potable112115363_potable
quotable1936493quotable
ratable91717553_ratable
rateable10311443rateable
readable11313163readable
reapable12311393reapable
rebuttable1443953rebuttable
reefable1339533reefable
reelable10311593reelable
refutable1477863refutable
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
unactable13310053unactable
unbeatable1447833unbeatable
undatable1238983undatable
unstable10313763unstable
untenable11410503untenable
untestable1248823untestable
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.440406115.9
2DLD Change Limit1461621866.59322169.3
3Display Results1861860.0762447.4
 (SQL Overall)1786911867.10925135.9
 
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.