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

257 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
statable1031070(None) 
stateable1136901stateable
abatable1238022abatable
beatable121612242beatable
boatable121610262boatable
datable101714232_datable
eatable91717602_eatable
getatable1235952getatable
hatable121713962_hatable
heatable131612042heatable
ratable91717552_ratable
rotatable1146652rotatable
salable91415462s_alable
satiable10310732satiable
savable121711862s_avable
sayable121411612s_ayable
scalable121710232scalable
sealable101512692sealable
shakable17177682shakable
shamable15168802shamable
shapable15197802shapable
sharable131910692sharable
shavable16177272shavable
slakable14177552slakable
slayable13157562slayable
sortable10312482sortable
sparable121611982sparable
stable83921642s__table
stackable1735992stackable
stageable1246342stageable
stainable1138092stainable
statal61613222stata_l_
statutable1242642statutable
stealable1136572stealable
stewable1337132stewable
stonable1039842stonable
storable10310732storable
stowable1337612stowable
suitable10310892suitable
swayable16135532swayable
takable13310192_takable
tamable11312852_tamable
tastable101511972_tastable
taxable1639072_taxable
totable92313362_totable
actable11313473_actable
adaptable1444613adaptable
agitable1138583agitable
arable81821003__arable
assayable1443643assayable
atonable1038793atonable
bearable121512363bearable
bitable11312203_bitable
blamable1436693blamable
bootable12179223bootable
capable13313363_capable
cartable121314093cartable
castable121613973castable
chantable1636893chantable
chartable1636833chartable
cheatable1646713cheatable
citable11313463_citable
creatable1339563creatable
cuttable1247953cuttable
dateable1149443dateable
debatable1446313debatable
dilatable1246853dilatable
draftable1575563draftable
drapable1377573drapable
drawable1467113drawable
eatables10169793_eatables
editable11310423editable
enactable1338493enactable
equatable2045193equatable
erasable10511043erasable
escapable1544983escapable
estimable1346043estimable
evadable1436363evadable
evitable1339323evitable
exactable2046433exactable
fadable13310463_fadable
fittable1337093fittable
floatable1444983floatable
foamable1537043foamable
framable1537573framable
getable101712553_getable
gettable11178133gettable
giftable1465893giftable
gnawable1435683gnawable
gradable1238823gradable
grantable1257293grantable
grazable2036223grazable
gustable11138203gustable
hateable1339373hateable
healable131610173healable
hearable131611603hearable
hittable1336853hittable
huntable1338093huntable
imitable1239123imitable
inarable10313133inarable
instable10313203instable
isolatable1244373isolatable
leasable101510133leasable
liftable1376863liftable
listable10810313listable
loanable1037613loanable
locatable1345573locatable
makable15510203_makable
meltable12310473meltable
metastable1444923metastable
mistakable1843103mistakable
mutable11312303_mutable
namable11312343_namable
nestable101613673nestable
nettable101610243nettable
notable92114903_notable
palatable1346373palatable
parable111819773_parable
payable141711323_payable
pettable121710713pettable
placable14169243placable
plantable1337273plantable
playable15137923playable
portable12313203portable
potable112115363_potable
quotable1936493quotable
ratables10159723_ratables
ratably121711513_ratably
rateable10311443rateable
readable11313163readable
reapable12311393reapable
relatable11310053relatable
rentable101716333rentable
restable101618443restable
restartable1343543restartable
retable91820403_retable
rustable101511363rustable
sable74732163s___able
sailable10310563sailable
salably121610743s_alably
saleable10312023saleable
salvable1338403salvable
sandable111612823sandable
satiably1337823satiably
saturable1146633saturable
saveable1339003saveable
scabble13168653sca_bble
scalably15166703scalably
scannable1345643scannable
scrutable1346043scrutable
seeable91113943s_eeable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
separable1348673separable
servable13310093servable
sewable121911173s_ewable
shakeable1844943shakeable
shamably18165803shamably
shamble14149263sha_mble
shameable1645573shameable
shapeable1645743shapeable
shareable1436733shareable
shedable1437423shedable
shiftable1744893shiftable
showable1636583showable
singable11159543singable
sinkable14178413sinkable
sizable1839893s_izable
sizeable1937113sizeable
skatole1135693skat_ole
skiable1338883s_kiable
slidable1137953slidable
smokable1636223smokable
sociable1239503sociable
solvable1337473solvable
sorbable1239303sorbable
sortably1338803sortably
sowable121610753s_owable
spallable1345833spallable
sparables13167163sparables
spareable1337263spareable
spatzle1834583spat_zle
speakable1745373speakable
spottable1345343spottable
stabile9312063sta_bile
stabled103514953s__tabled
stabler94014933s__tabler
stables93219073s__tables
stably113314123s__tably
staddle9288093sta_ddle
stale55637103s__ta_le
staple84415823s__taple
startle72511123sta_rtle
statant7313123stata_nt
state56237333stat___e
statedly1245833statedly
stately10310223stat_ely
statice92614033stat_ice
stative102612933stat_ive
statue66015323stat__ue
stature74410683stat_ure
statute7419323stat_ute
steerable1146913steerable
stickable1745543stickable
stoppable1544103stoppable
storables1146283storables
stratal72710603strata_l_
stubble1136843st_ubble
stumble1147553st_umble
suable83920553s__uable
suitably1347593suitably
summable1436903summable
surfable1338443surfable
syllable13177773syllable
table75429603___table
takeable1437463_takeable
talkable1437193_talkable
tamale83717403_tama_le
tameable1238603_tameable
tannable1039383_tannable
tapeable1238823_tapeable
tappable1436343_tappable
tasteable1146123_tasteable
tattle64115653_tat_tle
taxables1734383_taxables
taxably1936043_taxably
tearable101512673tearable
teasable101511173teasable
tenable93214493_tenable
testable101412623testable
tiltable10159013tiltable
tithable1336853_tithable
titrable1038963_titrable
titratable1243693titratable
toteable1048353_toteable
towable121910113_towable
tractable1338513tractable
tradable1139873tradable
treatable1139323treatable
triable92515393_triable
tunable92511313_tunable
typable1435883_typable
unactable13310053unactable
undatable1238983undatable
uneatable11311693uneatable
unstable10313763unstable
untamable1347843untamable
vacatable1644643vacatable
votable122111373_votable
wadable13310233_wadable
wastable131410453wastable
waxable1937673_waxable
wearable131510553wearable
wettable13148043wettable
writable1338753writable

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622578.00018270.3
3Display Results2572570.1102336.4
 (SQL Overall)1786912578.53320941.2
 
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.