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

108 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
shareable143673(None) 
shakeable1844941shakeable
shameable1645571shameable
shapeable1645741shapeable
sharable131910691shar_able
spareable1337261spareable
chargeable1843472chargeable
chartable1636832chartable
chaseable1646342chaseable
hateable1339372_hateable
hireable13139082_hireable
saleable10312022s_aleable
saveable1339002s_aveable
shakable17177682sha_kable
shamable15168802sha_mable
shameably1943872shameably
shapable15197802sha_pable
shavable16177272sha_vable
sparable121611982spar_able
stageable1246342stageable
stateable1136902stateable
alarmable1345013alarmable
arable81821003__ar_able
awardable1543953awardable
barrable1249253_barrable
bearable121512363bear_able
blameable1544723blameable
boardable1444893boardable
cartable121314093_cartable
changeable1843963changeable
chantable1636893chantable
charitable1744643charitable
chokeable2053853chokeable
dateable1149443_dateable
drapeable1445673drapeable
faceable15108493_faceable
farmable1538203_farmable
fireable131710223_fireable
frameable1645353frameable
grazeable2144153grazeable
hackable1937473_hackable
hangable1438213_hangable
hatable121713963_ha_table
hearable131611613hear_able
hirable121612313_hir_able
imageable1445443imageable
inarable10313133inar_able
learnable1145563learnable
makeable1637253_makeable
nameable1238863_nameable
parable111819783_par_able
parsable12311693_parsable
peaceable1548253peaceable
placeable1536913placeable
rateable10311443_rateable
sailable10310563s_ailable
salable91415463s_a_lable
saleably1338213s_aleably
salvable1338403s_alvable
sandable111612823s_andable
satiable10310733s_atiable
savable121711863s_a_vable
sayable121411613s_a_yable
scalable121710233sca_lable
scannable1345643scannable
screwable1644843s_crewable
sealable101512693sea_lable
searchable1744143searchable
seeable91113943s__eeable
separable1348673separ_able
servable13310093s_ervable
severable1438543severable
shamably18165803sha_mably
shamble14149263sha__mble
shareware1544333shareware
shedable1437423sh_edable
sheddable1643693sheddable
shiftable1744893shiftable
shippable1853793shippable
shockable2044703shockable
showable1636583sh_owable
shunnable1443203shunnable
sizeable1937113s_izeable
slakable14177553sla_kable
slayable13157563sla_yable
sliceable1345443sliceable
smokeable1743853smokeable
sorbable1239303s_orbable
sortable10312483s_ortable
spallable1345833spallable
sparables13167173spar_ables
stackable1735993stackable
stainable1138093stainable
statable10310703sta_table
steerable1146913steerable
storable10310733stor_able
superable13312483superable
surfable1338443s_urfable
swayable16135533swa_yable
takeable1437463_takeable
tameable1238603_tameable
tapeable1238823_tapeable
tearable101512673tear_able
traceable1338323traceable
tradeable1247413tradeable
variable13310063_variable
wadeable1437443_wadeable
wearable131510563wear_able

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 Filter1786911486410.516346300.4
2DLD Change Limit1486411088.68617112.7
3Display Results1081080.0462347.8
 (SQL Overall)1786911089.24819322.1
 
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.