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

452 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
usable8401255(None) 
sable74732161_sable
suable83920551suable
unable83819221unable
usably11288981usably
useable9911061useable
able66340532__able
abusable1236372abusable
amusable1237142amusable
arable81821002arable
buyable1437492buyable
cable95329912_cable
causable1239972causable
curable112414512curable
disable10516432disable
doable93115242doable
dupable12238382dupable
durable102312722durable
dyable12308982dyable
enable83318482enable
fable105824752_fable
fusible1237022fusible
gable85325522_gable
gustable11138202gustable
liable81415812liable
losable91910952losable
mutable11312302mutable
posable112212782posable
reusable10811272reusable
rulable9310532rulable
rustable101511352rustable
sabe66140572_sab_e
sables85026692_sables
sabre74821502_sabre
sale44959702_sa_le
stable83921642stable
suably112814532suably
table75429602_table
tunable92511312tunable
unbale83616402unbale
unstable10313762unstable
unusable1038952unusable
usage6410212usa_ge
usance858012usance
useably1287392useably
viable111613772viable
abbe87627183__abbe
abele76323253__abele
abled86926833__abled
abler75624313__abler
ables75935543__ables
ably99725133__ably
abye97921003__abye
accusable1544873accusable
actable11313473actable
addable11218843addable
affable15117403affable
ale36572343__a_le
alible8311973alible
amble95924633_amble
amiable11312033amiable
arables91814973arables
arousable1145573arousable
audible10228243audible
axle116424603__axle
babble94017113babble
babe86835813_bab_e
babel95821693_babel
bale66353843_ba_le
bauble103813213bauble
beadle93314683beadle
beagle93612593beagle
bible95119413_bible
bitable11312203bitable
bobble94115143bobble
brabble10349973brabble
bramble133710033bramble
bubale104014623buba_le
bubble94016593bubble
buffable1844393buffable
bumble124216893bumble
burble104617703burble
burnable1237263burnable
bustle84015483bus_tle
cabled114819873_cabled
cabler104519173_cabler
cables104527553_cables
cablet104429463_cablet
capable13313363capable
carle74535703_carle
cascable141510623cascable
cashable15159793cashable
castable121613973castable
castle84918963castle
citable11313463citable
closable12168003closable
clubable1436093clubable
cobble123615263cobble
coble94823173_coble
codable12311663codable
cradle93313163cradle
crushable1645263crushable
culpable1436283culpable
curably142010773curably
curbable1447663curbable
cuttable1247953cuttable
dabble114515193dabble
dale55643983_da_le
datable101714233datable
dibble114013843dibble
disabled1248713disabled
disabler1147913disabler
disables11410903disables
double94013993double
dowable13189453dowable
drabble12238883drabble
drably123511613drably
dryable13237433dryable
durables11237013durables
durably13229053durably
dutiable1137373dutiable
dyeable1337303dyeable
eagle64219483_eagle
eatable91717603eatable
edible969353edible
educable1337083educable
effable15106673effable
enabled102510633enabled
enabler9299363enabler
enables92813123enables
equable1849253equable
erasable10511043erasable
errable9312183errable
eustele738193eustele
excusable2044373excusable
eyeable1239063eyeable
fabled124216383_fabled
fabler116115813_fabler
fables114921673_fables
fadable13310463fadable
farle86929243_farle
feeble1138253feeble
fimble133611743fimble
finable122213623finable
fishable1637593fishable
fixable19218193fixable
flushable1743573flushable
flyable15307123flyable
focusable1644093focusable
foible11410383foible
friable122612563friable
fryable15277463fryable
fumble133214263fumble
furlable1335893furlable
fusibly1535863fusibly
fusile94313493fus_ile
gabble113815723gabble
gabled105518453_gabled
gables94222333_gables
gale56347323_ga_le
gamble115417183gamble
garble94118453garble
gelable101710733gelable
getable101712553getable
gobble113512983gobble
grabble12339643grabble
guessable1243733guessable
guidable1236203guidable
gullable1136463gullable
gustables12165223gustables
habile11515203_habile
hale76052833_ha_le
haole84820083_haole
hassle93711593hassle
hatable121713963hatable
hewable15177823hewable
hidable1399403hidable
hirable121612313hirable
hobble133913433hobble
huggable1543333huggable
humble133615053humble
hummable1744583hummable
huntable1338093huntable
hustle93113993hus_tle
instable10313193instable
isle45121703is__le
isolable1038793isolable
issuable1046873issuable
istle52214713is_tle
jumble174012653jumble
jumpable2143953jumpable
justle133211583jus_tle
kale86533753_ka_le
kibble143910953kibble
kissable1436853kissable
label75019383_label
labile8315213_labile
ladle66320443_ladle
lapsable12117383lapsable
laudable1137893laudable
leasable101510133leasable
likable13219413likable
linable92214343linable
listable10810303listable
livable122010323livable
lovable12179553lovable
mabe85733343_mab_e
macle96127003_macle
maile75232213_maile
makable15510203makable
male66052293_ma_le
maple95521143_maple
marble104219103marble
maskable1638003maskable
measle83513223measle
minable112315073minable
missable12311533missable
mixable18259173mixable
movable14189433movable
mumble123614343mumble
muscle10310973mus_cle
mutably1438613mutably
nabe66029493_nab_e
namable11312333namable
nestable101613673nestable
nibble103713283nibble
nimble103412933nimble
nobble103814313nobble
noble74420993_noble
nonusable1146743nonusable
notable92114903notable
nubble103813713nubble
oracle84313293oracle
oscule838193oscule
osmole8128513osmole
outfable1378813outfable
ownable1237283ownable
padle84522343_padle
pale66055013_pa_le
parable111819773parable
parle75836163_parle
parsable12311693parsable
passable12310623passable
payable141711323payable
pebble1238003pebble
perusable1347453perusable
pliable111610323pliable
pokable15209503pokable
potable112115363potable
pourable1239133pourable
prunable1237843prunable
psalm949273psa_lm
pursuable1344693pursuable
pustule937683pustule
quale143617853qua_le
quibble2034713quibble
quotable1936493quotable
rabble103818243rabble
raisable10311643raisable
rale45050563_ra_le
ramble104519973ramble
rassle63813203rassle
ratable91717553ratable
refusable1476683refusable
resale64025543resa_le
restable101618433restable
retable91820403retable
reusables1175223reusables
ridable101412493ridable
rinsable10310033rinsable
risible937923risible
roble75223023_roble
ropable111611333ropable
rouble83913313rouble
rowable121510303rowable
rubble104315673rubble
ruble74521253_ruble
ruinable1039263ruinable
rumble103718813rumble
rustle63615413rus_tle
sab56563203_sab__
sabal75422483_sabal
sabals84618863_sabals
sabbed114518083_sabbed
sabed86526813_sabed
saber75330243_saber
sabes76437463_sabes
sabin74924943_sabin
sabine84020383_sabine
sabir75916993_sabir
sabot7931773_sabot
sabra75317853_sabra
sabred95916533_sabred
sabres85520863_sabres
sabs66643743_sab_s
saddle83915493_saddle
sade55544473_sa_de
sadhe94815133_sadhe
sadly94519123_sadly
sae38365183_sa__e
safe75930953_sa_fe
sage55044593_sa_ge
saice75424053_saice
sail45447163_sail_
sailed74327763_sailed
sailer63526103_sailer
sails55738103_sails
sake85244963_sa_ke
sal36462883_sa_l_
salable91415463salable
salep77022953_sa_lep
sales56055593_sa_les
sall44544683_sa_ll
sallet63734543_sallet
sally85129713_sally
salp64534093_sa_lp
sals46851673_sa_ls
salt45758523_sa_lt
salve85022133_salve
same65245643_sa_me
samlet84126563_samlet
sample104215013_sample
sane45954333_sa_ne
saree55044663_saree
sarge65531133_sarge
sate45556103_sa_te
sauce75121653_sauce
saul45836523_saul_
sauls55128123_sauls
sault55834963_sault
saute55028083_saute
savable121711863savable
save75741363_sa_ve
sayable121411613sayable
scabble13168653scabble
scale74629143_scale
seeable91113943seeable
seisable10311373seisable
selle54428313_selle
sewable121911173sewable
shale85332833_shale
shamble14149263shamble
sidle65124033_sidle
sizable1839893sizable
skiable1338883skiable
smile74823913_smile
socle7419573_socle
sole46053673_s_ole
sowable121610753sowable
spale74929213_spale
spile75230083_spile
stabile9312063stabile
stabled103514953stabled
stabler94014933stabler
stables93219073stables
stably113314123stably
stale55637103_stale
staple84415823staple
stele55026843_stele
stile54931573_stile
stole54928813_stole
style85519363_style
suave83519873sua_ve
sublet82827243_sublet
subsale9310543subsa_le
subtle82113433subtle
suckle124015963suckle
suitable10310893suitable
summable1436903summable
supple10410203supple
surfable1338443surfable
swale85221593_swale
tabla73318363_tabla
tabled94020043_tabled
tables84524883_tables
tablet84227643_tablet
takable13310193takable
tale46154163_ta_le
tamable11312843tamable
tastable101511973tastable
taxable1639073taxable
teasable101511173teasable
teazle15329553teazle
tenable93214493tenable
testable101412623testable
totable92313363totable
towable121910113towable
treble8311663treble
triable92515393triable
trustable1147123trustable
tsade64311123tsa_de
tubbable1134683tubbable
tumble103215643tumble
tunably12218293tunably
tuneable1038913tuneable
turnable1037853turnable
tussle637143tus_sle
typable1435883typable
ukase9428493uka_se
umbel93612833u_mbel
umbles103817483u_mbles
unagile838283unagile
unbaled103315963unbaled
unbales92914863unbales
unbe65319273u_nb_e
uncle7317053u_ncle
undoable1139053undoable
unpile81914323unpile
unsaddle1044753unsaddle
unsafe9310693unsa_fe
unsalable1148993unsalable
unsayable1447223unsayable
unseeable1149453unseeable
unstabler1145623unstabler
unstably1339493unstably
unsubtle1043873unsubtle
unviable1338703unviable
upbye1244793u_pbye
uppile10178503uppile
upscale11136323upscale
urare56322553ura_re
urase54624683ura_se
urate55432163ura_te
urbane82211383urbane
ursae55214453ursa__e
usages759603usages
usances967373usances
usaunce9103383usaunce
use36835163us___e
usquabae1941893usquabae
usque14137733us_que
usual5310183usual_
usually1066063usually
usuals637783usuals
utile54718933u_tile
vale74937343_va_le
viably14199833viably
visible1236923visible
vocable14189673vocable
votable122111373votable
wabble133714843wabble
wadable13310233wadable
wale74546433_wa_le
wamble134415753wamble
warble113516603warble
washable16138043washable
wastable131410453wastable
waxable1937673waxable
whale115517433wha_le
wimble133211913wimble
wirable121610963wirable
wobble133212313wobble

Search took 6 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127164525.62620034.8
3Display Results4524520.1562897.4
 (SQL Overall)1786914525.92230174.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.