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

182 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
typable143588(None) 
typeable1535231typeable
capable13313362capable
dupable12238382dupable
dyable12308982dy_able
dyeable1337302dyeable
eyeable1239062eyeable
ropable111611332ropable
table75429602t__able
takable13310192takable
tamable11312852tamable
tapeable1238822tapeable
tappable1436342tappable
taxable1639072taxable
tenable93214492tenable
tippable1435262tippable
totable92313362totable
towable121910112towable
triable92515392triable
tunable92511312tunable
typal105311152typa_l_
able66340533___able
actable11313473actable
addable11218843addable
affable15117403affable
amiable11312033amiable
arable81821003_arable
atonable1038793atonable
bitable11312203bitable
buyable1437493buyable
cable95329913__cable
capabler1435353capabler
capably1639253capably
citable11313463citable
codable12311663codable
copyable1736623copyable
culpable1436283culpable
curable112414513curable
datable101714233datable
dippable1536123dippable
disable10516433disable
doable93115243_doable
dowable13189453dowable
drapable1377573drapable
dryable13237433dryable
durable102312723durable
eatable91717603eatable
effable15106673effable
empale102611263empa_le
enable83318483_enable
equable1849253equable
errable9312183errable
expiable1946113expiable
fable105824753__fable
fadable13310463fadable
finable122213623finable
fixable19218193fixable
flyable15307123flyable
friable122612563friable
fryable15277463fryable
gable85325523__gable
gelable101710733gelable
getable101712553getable
hatable121713963hatable
helpable1536603helpable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
impale102811663impa_le
jumpable2143953jumpable
keepable1635323keepable
lapsable12117383lapsable
liable81415813_liable
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
makable15510203makable
mappable1635923mappable
minable112315073minable
mixable18259173mixable
movable14189433movable
mutable11312303mutable
namable11312343namable
notable92114903notable
ownable1237283ownable
padle84522343__padle
pale66055013__pa_le
palpable1448033palpable
parable111819773parable
parle75836163__parle
payable141711323payable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
ratable91717553ratable
reapable12311393reapable
retable91820403retable
ridable101412493ridable
rippable1435383rippable
rowable121510303rowable
rulable9310533rulable
sable74732163__sable
salable91415463salable
savable121711863savable
sayable121411613sayable
seeable91113943seeable
sewable121911173sewable
shapable15197803shapable
sizable1839893sizable
skiable1338883skiable
sowable121610753sowable
spale74929213_spa_le
stable83921643_stable
statable10310703statable
stewable1337133stewable
stonable1039843stonable
stoppable1544103stoppable
storable10310733storable
stowable1337613stowable
suable83920553_suable
syllable13177773syllable
tabla73318363t__abla
tabled94020043t__abled
tables84524893t__ables
tablet84227643t__ablet
takeable1437463takeable
tale46154163t__a_le
talkable1437193talkable
tamale83717403tama_le
tameable1238603tameable
tannable1039383tannable
tapalo839793tapa_lo
taphole1239773taphole
tastable101511973tastable
taxables1734383taxables
taxably1936043taxably
tearable101512673tearable
teasable101511173teasable
teazle15329553t_eazle
tellable10169773tellable
temptable1545813temptable
tenably122210453tenably
tepal76319583tepa_l_
tepals85415043tepa_ls
testable101412623testable
thimble1435873thimble
tillable10159753tillable
tiltable10159013tiltable
timbale11248803timbale
tipple103411913tip_ple
tithable1336853tithable
titrable1038963titrable
topple104411323top_ple
toteable1048353toteable
tradable1139873tradable
treacle939973treacle
treadle8310103treadle
treble8311663t_reble
tremble1138003tremble
trouble957713trouble
tubbable1134683tubbable
tumble103215643t_umble
tunably12218293tunably
tuneable1038913tuneable
turnable1037853turnable
tymbal13236823tymbal_
tymbals14265723tymbals
type96223743typ___e
typebar1442993typebar
typhose1546693typhose
unable83819223_unable
usable84012553_usable
useable9911063useable
viable111613773_viable
vocable14189673vocable
votable122111373votable
wadable13310233wadable
waxable1937673waxable
wirable121610963wirable

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271826.28321331.7
3Display Results1821820.0603033.3
 (SQL Overall)1786911826.74926476.7
 
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.