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

180 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
stonable103984(None) 
atonable1038791atonable
storable10310731storable
stowable1337611stowable
atoneable1145852atoneable
detonable1247622detonable
showable1636582showable
smokable1636222smokable
sowable121610752s_owable
stable83921642st__able
stainable1138092stainable
statable10310702statable
stewable1337132stewable
stoppable1544102stoppable
storables1146282storables
tenable93214492_tenable
totable92313362_totable
towable121910112_towable
tunable92511312_tunable
actionable14116213actionable
adorable1138773adorable
amenable1238863amenable
atonal6514023atona_l_
atonally1148633atonally
avowable1635453avowable
bannable1278353bannable
bondable13169273_bondable
bookable16127003bookable
bootable12179223bootable
burnable1237263burnable
closable12168003closable
codable12311663_codable
coinable12311583coinable
cookable16147973cookable
damnable1347593damnable
doable93115243_do_able
dowable13189453_dowable
enable83318483__enable
erodable1139203erodable
estimable1346043estimable
evocable1537103evocable
exorable1738933exorable
finable122213623_finable
gainable1138933gainable
growable1435623growable
isolable1038793isolable
joinable1737283joinable
knowable1745043knowable
lienable10188693lienable
linable92214343_linable
listenable1243653listenable
loanable1037613loanable
losable91910953_losable
lovable12179553_lovable
minable112315073_minable
movable14189433_movable
notable92114903_notable
openable1247013openable
ownable1237283_ownable
pawnable1535983pawnable
plowable1535913plowable
pokable15209503_pokable
posable112212783_posable
postponable1752963postponable
potable112115363_potable
probable1439053probable
provable1539093provable
prunable1237843prunable
quotable1936493quotable
restorable1246753restorable
ropable111611333_ropable
rowable121510303_rowable
ruinable1039263ruinable
sable74732163s___able
sailable10310563sailable
salable91415463s_alable
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiable10310733satiable
saturable1146633saturable
savable121711863s_avable
saveable1339003saveable
sayable121411613s_ayable
scalable121710233scalable
scannable1345643scannable
scoopable1544863scoopable
sealable101512693sealable
seasonable1244933seasonable
seeable91113943s_eeable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310093servable
sewable121911173s_ewable
shakable17177683shakable
shamable15168803shamable
shapable15197803shapable
sharable131910693sharable
shavable16177273shavable
shedable1437423shedable
shockable2044703shockable
shunnable1443203shunnable
singable11159543singable
sinkable14178413sinkable
sizable1839893s_izable
sizeable1937113sizeable
skiable1338883s_kiable
slakable14177553slakable
slayable13157563slayable
slidable1137953slidable
smokeable1743853smokeable
sociable1239503sociable
soluble966103s_oluble
solvable1337473solvable
sonance9310313s_onance
sorbable1239303sorbable
sortable10312483sortable
soundable1245983soundable
sparable121611983sparable
spendable1446463spendable
spoilable1345163spoilable
spottable1345343spottable
stabile9312063st__abile
stabled103514953st__abled
stabler94014933st__abler
stables93219073st__ables
stably113314123st__ably
stackable1735993stackable
stageable1246343stageable
stale55637103st__a_le
staple84415823st__aple
stateable1136903stateable
stealable1136573stealable
steerable1146913steerable
stickable1745543stickable
stoae55024263sto_a__e
stole54928813sto___le
stomal85213313stoma_l_
stomate9313123stoma_te
stone55431183ston___e
stonefly1443473stonefly
stonily1049433ston_ily
stopple1156583sto_pple
storage8310473stora_ge
stowage1136703stowa_ge
strangle98411503strangle
strongyle1343113strongyle
stubble1136843st_ubble
stumble1147553st_umble
suable83920553s__uable
suitable10310893suitable
summable1436903summable
summonable1662953summonable
surfable1338443surfable
swayable16135533swayable
syllable13177773syllable
table75429603_t__able
takable13310193_takable
tamable11312853_tamable
tannable1039383tannable
taxable1639073_taxable
tenably122210453_tenably
tonal53724303_tona_l_
tonally10311373_tonally
toteable1048353_toteable
triable92515393_triable
tunably12218293_tunably
tuneable1038913_tuneable
turnable1037853turnable
typable1435883_typable
unable83819223__unable
untenable11410503untenable
untunable1147833untunable
violable1337543violable
vocable14189673_vocable
votable122111373_votable
voteable1347213voteable
winnable13156983winnable

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.830215290.4
2DLD Change Limit1461621808.37617450.1
3Display Results1801800.0603000.0
 (SQL Overall)1786911809.26619284.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.