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

94 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
speakable174537(None) 
breakable1746162breakable
sealable101512692s_ealable
separable1348672separable
shakable17177682s_hakable
slakable14177552s_lakable
sparable121611982sp_arable
spendable1446462spendable
spreadable1544422spreadable
stealable1136572stealable
unspeakable1944302unspeakable
appealable1643853appealable
appeasable1644593appeasable
bearable121512363_bearable
beatable121612243_beatable
breakables1842753breakables
cheatable1646713cheatable
checkable2244743checkable
cleanable1345203cleanable
clearable1346013clearable
cleavable1644473cleavable
creatable1339563creatable
eatable91717603__eatable
gleanable1244083gleanable
healable131610173_healable
hearable131611603_hearable
heatable131612043_heatable
kneadable1645673kneadable
leasable101510133_leasable
makable15510203__makable
openable1247013ope_nable
operable12410323ope_rable
packable1838633_packable
parable111819773_p_arable
payable141711323_p_ayable
peaceable1548253_peaceable
peccable1648123_peccable
peelable1238553_peelable
pettable121710713_pettable
placable14169243_placable
playable15137923_playable
pleadable1445513pleadable
pokable15209503_p_okable
readable11313163_readable
reapable12311393_reapable
reparable1359953reparable
repayable1666343repayable
repealable1445983repealable
repeatable1447603repeatable
salable91415463s__alable
savable121711863s__avable
sayable121411613s__ayable
scalable121710233s_calable
seeable91113943s_e_eable
seisable10311373s_eisable
seizable1938723s_eizable
sellable101711823s_ellable
sendable111612043s_endable
separably1655773separably
servable13310093s_ervable
sewable121911173s_e_wable
shakeable1844943s_hakeable
shamable15168803s_hamable
shapable15197803s_hapable
sharable131910693s_harable
shavable16177273s_havable
shedable1437423she_dable
sheddable1643693sheddable
shockable2044703shockable
sinkable14178413s_inkable
slayable13157563s_layable
smokable1636223s_mokable
spallable1345833spallable
sparables13167163sp_arables
spareable1337263spareable
speckle15297553speck__le
spectacle1544083spectacle
spillable1345353spillable
spoilable1345163spoilable
spottable1345343spottable
stackable1735993stackable
statable10310703s_tatable
steerable1146913steerable
stewable1337133ste_wable
stickable1745543stickable
superable13312483supe_rable
swayable16135533s_wayable
takable13310193__takable
tearable101512673_tearable
teasable101511173_teasable
treatable1139323treatable
uneatable11311693uneatable
unspeakably2253023unspeakably
wearable131510553_wearable

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.530337152.8
2DLD Change Limit148641947.78019105.5
3Display Results94940.0501880.0
 (SQL Overall)178691948.36021374.5
 
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.