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

294 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
useable991106(None) 
usable84012551us_able
useably1287391useably
dyeable1337302dyeable
eyeable1239062eyeable
gustable11138202gustable
rustable101511362rustable
sable74732162_s_able
seeable91113942seeable
sewable121911172_sewable
stable83921642_stable
suable83920552_suable
tuneable1038912tuneable
unable83819222u_nable
unseeable1149452unseeable
unstable10313762unstable
usably11288982us_ably
able66340533___able
abusable1236373abus_able
actable11313473actable
addable11218843addable
affable15117403affable
amenable1238863amenable
amiable11312033amiable
amusable1237143amus_able
arable81821003_arable
assemble1254823assemble
beadle93314683_beadle
beagle93612593_beagle
bitable11312203bitable
biteable1237933biteable
buffable1844393buffable
burnable1237263burnable
buyable1437493buyable
cable95329913__cable
capable13313363capable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973caus_able
chaseable1646343chaseable
chewable1835443chewable
citable11313463citable
citeable1238413citeable
closeable13155023closeable
codable12311663codable
crushable1645263crushable
culpable1436283culpable
curable112414513curable
curbable1447663curbable
cuttable1247953cuttable
datable101714233datable
dateable1149443dateable
disable10516433disable
disenable1249673disenable
doable93115243_doable
dowable13189453dowable
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dutiable1137373dutiable
dyable12308983_dyable
eagle64219483__eagle
eatable91717603eatable
effable15106673effable
enable83318483_enable
ensemble1244973ensemble
equable1849253equable
errable9312183errable
fable105824753__fable
faceable15108493faceable
fadable13310463fadable
feeble1138253_feeble
feedable1437673feedable
fileable13179223fileable
finable122213623finable
fineable131810333fineable
fireable131710223fireable
fishable1637593fishable
fixable19218193fixable
flushable1743573flushable
flyable15307123flyable
friable122612563friable
fryable15277463fryable
furlable1335893furlable
fusible1237023fus_ible
gable85325523__gable
gaugeable1342983gaugeable
gelable101710733gelable
getable101712553getable
giveable14155753giveable
guessable1243733guessable
guidable1236203guidable
gullable1136463gullable
gustables12165223gustables
hatable121713963hatable
hateable1339373hateable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
hireable13139083hireable
huggable1543333huggable
hummable1744583hummable
huntable1338093huntable
instable10313203instable
isolable1038793isolable
issuable1046873issuable
jumpable2143953jumpable
keepable1635323keepable
kissable1436853kissable
kleagle1242933kleagle
liable81415813_liable
lienable10188693lienable
likable13219413likable
likeable14166473likeable
linable92214343linable
lineable101811083lineable
listable10810313listable
livable122010323livable
liveable13177663liveable
losable91910953losable
lovable12179553lovable
loveable13187903loveable
makable15510203makable
makeable1637253makeable
maskable1638003maskable
measle83513223_measle
minable112315073minable
mineable121611053mineable
miserable1349653miserable
missable12311533missable
mixable18259173mixable
movable14189433movable
moveable15168013moveable
mutable11312303mutable
namable11312343namable
nameable1238863nameable
nestable101613673nestable
notable92114903notable
numerable1347623numerable
obeyable1544113obeyable
openable1247013openable
operable12410323operable
outfable1378813outfable
overable13513573overable
ownable1237283ownable
parable111819783parable
passable12310633passable
payable141711323payable
pebble1238003_pebble
peelable1238563peelable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
preamble1436383preamble
purgeable1444413purgeable
pursuable1344693pursuable
quotable1936493quotable
raiseable1147243raiseable
ratable91717553ratable
rateable10311443rateable
reefable1339533reefable
reelable10311603reelable
resale64025543resa_le
resemble1247313resemble
restable101618443restable
retable91820403retable
reusable10811273reus_able
ridable101412493ridable
rideable1158653rideable
ropable111611333ropable
rowable121510303rowable
ruinable1039263ruinable
rulable9310533rulable
sabe66140573_s_ab_e
sables85026693_s_ables
sabre74821503_s_abre
salable91415463salable
sale44959703_s_a_le
saleable10312023saleable
savable121711863savable
saveable1339003saveable
sayable121411613sayable
scabble13168653_scabble
scale74629143_sca_le
seabag938473_seabag
seabed95017693_seabed
seal45654373_sea_l_
sealable101512693_sealable
sealed74328363_sea_led
sealer63928963_sea_ler
seals54839703_sea_ls
seance83716693_seance
sedile73517233_sedile
seisable10311373_seisable
seizable1938723_seizable
sellable101711823_sellable
selle54428313_se_lle
semple103212753_semple
sendable111612043_sendable
senile63420213_senile
servable13310093_servable
settle63915663_settle
shale85332833_sha_le
shamble14149263_shamble
shedable1437423shedable
sizable1839893sizable
sizeable1937113sizeable
skiable1338883skiable
sowable121610753sowable
spale74929213_spa_le
stabile9312063_stabile
stabled103514953_stabled
stabler94014933_stabler
stables93219073_stables
stably113314123_stably
stale55637103_sta_le
staple84415823_staple
stewable1337133stewable
suably112814533_suably
suitable10310893suitable
summable1436903summable
superable13312483superable
surfable1338443surfable
swale85221593_swa_le
table75429603__table
takable13310193takable
takeable1437463takeable
tamable11312853tamable
tameable1238603tameable
tapeable1238823tapeable
tastable101511973tastable
tasteable1146123tasteable
taxable1639073taxable
teazle15329553_teazle
tenable93214493tenable
testable101412623testable
totable92313363totable
toteable1048353toteable
towable121910113towable
treacle939973treacle
treadle8310103treadle
treble8311663tre_ble
tremble1138003tremble
triable92515393triable
trustable1147123trustable
tubbable1134683tubbable
tunable92511313tunable
tuneably1346093tuneably
turnable1037853turnable
typable1435883typable
typeable1535233typeable
ukelele1142993ukelele
unbale83616403unba_le
undoable1139053undoable
unease63816643unea_se
uneatable11311693uneatable
unedible1146413unedible
unsalable1148993unsalable
unsayable1447223unsayable
unseal63315473unsea_l_
unsealed91513623unsea_led
unseals73212583unsea_ls
unsellable1247093unsellable
unsettle866063unsettle
unstabler1145623unstabler
unstably1339493unstably
untenable11410503untenable
unusable1038953unusable
unviable1338703unviable
upscale11136323upsca_le
ureal56722683urea_l_
urease64516993urea_se
usage6410213us_a_ge
usance858013us_ance
useful947013useful_
usquabae1941893usquabae
usual5310183usua_l_
usually1066063usually
usuals637793usua_ls
utterable1147153utterable
uveal84411073uvea_l_
viable111613773_viable
viewable1635223viewable
vocable14189673vocable
votable122111373votable
voteable1347213voteable
wadable13310233wadable
wadeable1437443wadeable
washable16138043washable
wastable131410453wastable
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.390458182.1
2DLD Change Limit1340272945.84322938.0
3Display Results2942940.1102672.7
 (SQL Overall)1786912946.34328171.4
 
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.