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 “testable” 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
testable10141262(None) 
nestable101613671nestable
restable101618431restable
tastable101511971tastable
beatable121612242beatable
castable121613972castable
detestable13136502detestable
eatable91717602_eatable
getable101712552ge_table
gettable11178132gettable
gustable11138202gustable
heatable131612042heatable
instable10313192instable
listable10810302listable
meltable12310472meltable
nettable101610242nettable
pettable121710712pettable
rentable101716332rentable
restabled12148942restabled
restables111511422restables
retable91820402re_table
rustable101511352rustable
stable83921642__stable
tasteable1146122tasteable
tearable101512672tearable
teasable101511172teasable
tellable10169772tellable
temptable1545812temptable
tenable93214492te_nable
tentacle1037692tentacle
testae64216252testa__e
testate73916232testa_te
testicle1037442testicle
tiltable10159012tiltable
totable92313362t_otable
treatable1139322treatable
trustable1147122trustable
twistable1444272twistable
unstable10313762unstable
untestable1248822untestable
wastable131410452wastable
wettable13148042wettable
abatable1238023abatable
actable11313473_actable
agitable1138583agitable
avertable14117343avertable
bearable121512363bearable
beddable14166923beddable
bendable131510853bendable
bitable11312203_bitable
boatable121610263boatable
bootable12179223bootable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
cheatable1646713cheatable
citable11313463_citable
constable13310993constable
contestable1546873contestable
creatable1339563creatable
cuttable1247953cuttable
datable101714233_datable
debatable1446313debatable
deletable12149503deletable
deniable11312083deniable
denotable1238373denotable
deputable1487033deputable
desirable1249393desirable
detectable15136593detectable
detestably16144393detestably
disable10516433dis_able
eatables10169793_eatables
editable11310423editable
effable15106673_effable
ejectable20136573ejectable
electable13149623electable
enable83318483_e_nable
equable1849253_equable
erectable131210093erectable
errable9312183_errable
estate64719763_esta_te
estimable1346043_estimable
evitable1339323evitable
eyeable1239063_eyeable
feedable1437673feedable
fellable13179133fellable
festal94213563festa_l_
festally1437543festally
fishable1637593fishable
fittable1337083fittable
gelable101710733ge_lable
gestalt8411163gesta_lt
gestate83614073gesta_te
getatable1235953getatable
giftable1465893giftable
guessable1243733guessable
gustables12165223gustables
hatable121713963_hatable
healable131610173healable
hearable131611603hearable
helpable1536603helpable
heritable1439453heritable
hewable15177823he_wable
hittable1336843hittable
huntable1338093huntable
imitable1239123imitable
investable1548043investable
issuable1046873issuable
keepable1635323keepable
kissable1436853kissable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liftable1376863liftable
losable91910953los_able
maskable1638003maskable
mendable131510583mendable
metastable1444923metastable
missable12311533missable
mutable11312303_mutable
nestle63013953nest__le
notable92114903_notable
obstacle1243593obstacle
passable12310623passable
patentable1444933patentable
peccable1648103peccable
peelable1238553peelable
pentacle1239383pentacle
pesthole1347553pesthole
pestle83215843pest__le
portable12313203portable
posable112212783pos_able
potable112115363_potable
quotable1936493quotable
ratable91717553_ratable
readable11313163readable
reapable12311393reapable
reefable1339533reefable
reelable10311593reelable
refutable1477863refutable
relatable11310053relatable
reliable10313073reliable
reputable1379123reputable
resalable1138733resalable
resale64025543res_a_le
rescale93215473resca_le
rescuable1347583rescuable
resectable1478123resectable
resemble1247303resemble
resettable1256503resettable
restage83316183resta_ge
restate73824873resta_te
restorable1246753restorable
restyle1038763rest_yle
resumable1347553resumable
retables101712673re_tables
reusable10811273reusable
sable74732163__s_able
sealable101512693sealable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310083servable
sewable121911173se_wable
sortable10312483sortable
stabile9312063__stabile
stabled103514953__stabled
stabler94014933__stabler
stables93219073__stables
stably113314123__stably
stale55637103__sta_le
staple84415823__staple
statable10310703statable
stealable1136573stealable
steerable1146913steerable
stewable1337133ste_wable
suable83920553__suable
suitable10310893suitable
table75429603___table
takable13310193t_akable
takeable1437463takeable
talkable1437193talkable
tamable11312843t_amable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
taxable1639073t_axable
teachable16137603teachable
teazle15329553te__azle
tectal83713253tecta_l_
telltale844423tellta_le
tenably122210453te_nably
tenantable1244183tenantable
tensible1037243tensible
tentacled1244953tentacled
tentacles1146713tentacles
tentage81010643tenta_ge
tenurable1147423tenurable
terrible1046643terrible
testa54822043testa___
testacies1148373testacies
testacy1235963testa_cy
testates83615443testates
testator847373testator
testee64323303test__ee
testicles1146773testicles
testily102910803test_ily
textile1437223text_ile
tillable10159753tillable
timetable1346873timetable
tippable1435263tippable
tithable1336853tithable
titrable1038963titrable
toteable1048353toteable
towable121910113t_owable
tractable1338513tractable
tradable1139873tradable
trestle72611363trest__le
triable92515393t_riable
tubbable1134683tubbable
tunable92511313t_unable
tuneable1038913tuneable
turnable1037853turnable
turntable1144983turntable
typable1435883t_ypable
typeable1535233typeable
uneatable11311693uneatable
unstabler1145623unstabler
unstably1339493unstably
usable84012553_us_able
useable9911063_useable
vegetable1545683vegetable
vendable14159693vendable
veritable1448743veritable
vestal94615573vesta_l_
vestally1437413vestally
vestals104612333vesta_ls
vestibule1443693vestibule
visitable1445863visitable
votable122111373_votable
washable16138043washable
wearable131510553wearable
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.1731032896.0
2DLD Change Limit1461622478.81316584.8
3Display Results2472470.0932655.9
 (SQL Overall)1786912479.07919681.8
 
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.