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

115 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
spareable133726(None) 
shareable1436731shareable
sparable121611981spar_able
parable111819772_par_able
parsable12311692_parsable
saleable10312022s_aleable
saveable1339002s_aveable
separable1348672separ_able
shakeable1844942shakeable
shameable1645572shameable
shapeable1645742shapeable
sharable131910692shar_able
spallable1345832spallable
sparables13167162spar_ables
stageable1246342stageable
stateable1136902stateable
alarmable1345013alarmable
arable81821003__ar_able
awardable1543953awardable
barrable1249243_barrable
bearable121512363bear_able
blameable1544723blameable
boardable1444893boardable
cartable121314093_cartable
chargeable1843473chargeable
chartable1636833chartable
chaseable1646343chaseable
dateable1149443_dateable
drapeable1445673drapeable
faceable15108493_faceable
farmable1538203_farmable
fireable131710223_fireable
frameable1645353frameable
grazeable2144153grazeable
hateable1339373_hateable
hearable131611603hear_able
hireable13139083_hireable
imageable1445443imageable
inarable10313133inar_able
learnable1145563learnable
makeable1637253_makeable
nameable1238863_nameable
operable12410323oper_able
packable1838633_packable
palpable1448033_palpable
parables121613563_par_ables
parolable1347113_parolable
partible1238063_partible
passable12310633_passable
pawnable1535983_pawnable
payable141711323_pa_yable
peaceable1548253peaceable
permeable1556823_permeable
placeable1536913placeable
portable12313203_portable
preamble1436383_p_reamble
purgeable1444413_purgeable
rateable10311443_rateable
reparable1359953repar_able
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
separably1655773separ_ably
servable13310093s_ervable
severable1438543severable
shakable17177683sha_kable
shamable15168803sha_mable
shameably1943873shameably
shapable15197803sha_pable
shavable16177273sha_vable
sizeable1937113s_izeable
slakable14177553sla_kable
slayable13157563sla_yable
sliceable1345443sliceable
smokeable1743853smokeable
sorbable1239303s_orbable
sortable10312483s_ortable
spaetzle1942243spa_etzle
sparely123410673spare__ly
sparkle133710213spar__kle
speakable1745373speakable
spendable1446463spendable
spillable1345353spillable
spiracle1255803spir_acle
spoilable1345163spoilable
spottable1345343spottable
spreadable1544423sp_readable
stackable1735993stackable
stainable1138093stainable
statable10310703sta_table
steerable1146913steerable
storable10310733stor_able
superable13312483super_able
surfable1338443s_urfable
swayable16135533swa_yable
takeable1437463_takeable
tameable1238603_tameable
tapeable1238823_tapeable
tearable101512673tear_able
traceable1338323traceable
tradeable1247413tradeable
variable13310063_variable
wadeable1437443_wadeable
wearable131510553wear_able

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411156.90621523.5
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.37224239.1
 
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.