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 “storables” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

83 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
storables114628(None) 
storable10310731storable_
sparables13167172sparables
stables93219072st__ables
stonable1039842stonable_
storages9311102stora_ges
storaxes1536882stora_xes
stowable1337612stowable_
adorable1138773adorable_
arables91814983__arables
atonable1038793atonable_
chorales133712883chora_les
coracles121811163_coracles
durables11237013_durables
exorable1738933exorable_
morales93619403_mora_les
movables15175573_movables
notables10178243_notables
oracles93212423__oracles
parables121613573_parables
pastorales1247143pastora_les
portables1337873_portables
potables12179703_potables
probables1545433probables
restorable1246753restorable_
sables85026693s___ables
saturable1146633saturable_
scrabbles15206283s_crabbles
scrambles15146383s_crambles
sharable131910693sharable_
showable1636583showable_
smokable1636223smokable_
sociables1344963sociables
solubles1065893s_olubles
sorbable1239303s_orbable_
sorbates10311103s_orbates
sortable10312483s_ortable_
sowable121610753s_owable_
sparable121611983sparable_
spiracles1345663spiracles
sporules1037703spor_ules
stabiles10311403st__abiles
stable83921643st__able_
stabled103514953st__abled
stabler94014933st__abler
stablers103611153st__ablers
stablest103312943st__ablest
stales65538293st__a_les
staples93617213st__aples
startles82111963star_tles
statable10310703statable_
steerable1146913steerable_
stewable1337133stewable_
stoles63927673sto___les
stomates10313343stoma_tes
stoppable1544103stoppable_
stopples1236953sto_pples
storage8310473stora_ge_
stores65533663stor___es
stories7324273stor__ies
stowages1236473stowa_ges
straddles11216403st_raddles
strafes104516003st_ra_fes
straggles11328503st_raggles
strakes114218073st_ra_kes
stranges94516763st_ranges
strangles103011563st_rangles
strapless1135793st_rapless
strasses81311443st_rasses
strobes93813263st_rob_es
strobiles1146953strobiles
stubbles1236843st_ubbles
stumbles1237493st_umbles
styraxes1833493styra_xes
syllables14144753syllables
tables84524893_t__ables
taxables1734383_taxables
totable92313363_totable_
towable121910113_towable_
trebles9311443_t_rebles
troubles1057203_troubles
vocables15145733_vocables
wearables14155013wearables

Search took 9 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 Filter1786911486410.466383457.1
2DLD Change Limit148641837.65619415.0
3Display Results83830.0332515.2
 (SQL Overall)178691838.15521911.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.