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

316 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
errable931218(None) 
arable81821002_arable
averrable14105412averrable
barrable1249242barrable
bearable121512362bearable
curable112414512curable
dryable13237432dryable
durable102312722durable
eatable91717602eatable
effable15106672effable
enable83318482e_nable
equable1849252equable
erasable10511042erasable
erodable1139202erodable
exorable1738932exorable
eyeable1239062eyeable
friable122612562friable
fryable15277462fryable
hearable131611602hearable
hirable121612312hirable
inerrable11410152inerrable
parable111819772parable
retable91820402retable
servable13310082servable
tearable101512672tearable
terrible1046642terrible
triable92515392triable
wearable131510552wearable
wirable121610962wirable
able66340533___able
actable11313473actable
addable11218843addable
adorable1138773adorable
affable15117403affable
amiable11312033amiable
arables91814973_arables
arguable1135903arguable
arrange838683arrange
avertable14117343avertable
bearably15177933bearably
beatable121612243beatable
beddable14166923beddable
bendable131510853bendable
bitable11312203bitable
brabble10349973brabble
bramble133710033bramble
bribable1137223bribable
burble104617703bur_ble
burnable1237263burnable
buyable1437493buyable
cable95329913__cable
capable13313363capable
cartable121314093cartable
citable11313463citable
clearable1346013clearable
codable12311663codable
coracle112011723coracle
cradle93313163_cradle
crumble133410403crumble
curably142010773curably
curbable1447663curbable
datable101714233datable
deferrable1644853deferrable
deniable11312083deniable
derivable1548063derivable
desirable1249393desirable
deterrable1345723deterrable
disable10516433disable
doable93115243_doable
dowable13189453dowable
drabble12238883drabble
drably123511613_drably
drapable1377573drapable
drawable1467113drawable
dribble12368603dribble
drivable1438023drivable
drumble12337893drumble
dupable12238383dupable
durables11237013durables
durably13229053durably
dyable12308983_dyable
dyeable1337303dyeable
eagle64219483e__agle
earache1239323earache
eatables10169793eatables
edible969353e_dible
editable11310423editable
educable1337093educable
empale102611263empa_le
enabled102510633e_nabled
enabler9299363e_nabler
enables92813123e_nables
endurable1247733endurable
ennoble935633ennoble
enrage72715073enra_ge
enrobe86610793enrob_e
enterable11312643enterable
enviable1337853enviable
equably2136183equably
erase54925493e_ra_se
erectable131210093erectable
ergate7315143erga_te
erodible1145493erodible
erosible1046443erosible
errancy1256363errancy
errand758793erra_nd
errands847603errands
errant6618733erra_nt
errantly1175793errantly
errants7410643errants
errata639013erra_ta
erratas736863erratas
erratic9311113erratic
erratum944503erratum
errhine1036593errhine
evadable1436363evadable
evitable1339323evitable
evocable1537103evocable
execrable2046233execrable
exhale1636873exha_le
exilable1737203exilable
expiable1946113expiable
fable105824753__fable
fadable13310463fadable
farmable1538203farmable
feedable1437673feedable
fellable13179133fellable
ferrate103014043ferra_te
ferrule1035863ferr_ule
finable122213623finable
fireable131710223fireable
fixable19218193fixable
flyable15307123flyable
fordable1439593fordable
formable1539503formable
framable1537573framable
fribble14287783fribble
furlable1335893furlable
gable85325523__gable
garble94118453gar_ble
gelable101710733gelable
generable1238663generable
getable101712553getable
gettable11178133gettable
grabble12339643grabble
gradable1238823gradable
grazable2036223grazable
gribble12297273gribble
growable1435623growable
grumble12349233grumble
hatable121713963hatable
healable131610173healable
heatable131612043heatable
helpable1536603helpable
heritable1439453heritable
hewable15177823hewable
hidable1399403hidable
hireable13139083hireable
horrible13135233horrible
inarable10313133inarable
irrigable1246233irrigable
irritable1148053irritable
keepable1635323keepable
learnable1145563learnable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liable81415813_liable
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
makable15510203makable
marble104219103mar_ble
meltable12310473meltable
memorable1547533memorable
mendable131510583mendable
minable112315073minable
miracle1138843miracle
mixable18259173mixable
morale85220553mora_le
movable14189433movable
mutable11312303mutable
namable11312343namable
nestable101613673nestable
nettable101610243nettable
notable92114903notable
operable12410323operable
oracle84313293_oracle
orderable1246183orderable
overable13513573overable
ownable1237283ownable
parables121613563parables
parsable12311693parsable
payable141711323payable
peccable1648123peccable
peelable1238553peelable
percale11314093perca_le
perdurable1544753perdurable
permeable1556813permeable
perusable1347453perusable
petrale9312623petra_le
pettable121710713pettable
pliable111610323pliable
pokable15209503pokable
portable12313203portable
posable112212783posable
potable112115363potable
pourable1239133pourable
preamble1436383preamble
probable1439053probable
provable1539093provable
prunable1237843prunable
rabble103818243_rabble
rale45050563__ra_le
ramble104519973_ramble
ratable91717553ratable
readable11313163readable
reapable12311393reapable
reefable1339533reefable
reelable10311593reelable
referable1439623referable
regale74821453rega_le
relabel938163relabel
reliable10313073reliable
rentable101716333rentable
reparable1359953reparable
reraise7316313reraise
resale64025543resa_le
restable101618443restable
retables101712673retables
reusable10811273reusable
reverable14310363reverable
ridable101412493ridable
roble75223023__roble
ropable111611333ropable
rouble83913313_rouble
rowable121510303rowable
rubble104315673_rubble
ruble74521253__ruble
rulable9310533rulable
rumble103718813_rumble
sable74732163__sable
salable91415463salable
savable121711863savable
sayable121411613sayable
scrabble14196993scrabble
scramble14177253scramble
sealable101512693sealable
securable1347773securable
seeable91113943seeable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
separable1348673separable
serrate73017543serra_te
severable1438543severable
sewable121911173sewable
sharable131910693sharable
sizable1839893sizable
skiable1338883skiable
sorbable1239303sorbable
sortable10312483sortable
sowable121610753sowable
sparable121611983sparable
stable83921643_stable
steerable1146913steerable
storable10310733storable
suable83920553_suable
surfable1338443surfable
table75429603__table
takable13310193takable
tamable11312853tamable
taxable1639073taxable
teasable101511173teasable
tellable10169773tellable
tenable93214493tenable
tenurable1147423tenurable
terrace93311843terra_ce
terrae62915213terra__e
terrane72814233terra_ne
terribly1344923terribly
testable101412623testable
titrable1038963titrable
totable92313363totable
towable121910113towable
tradable1139873tradable
treacle939973treacle
treadle8310103treadle
treble8311663_treble
tremble1138003tremble
trouble957713trouble
tunable92511313tunable
turnable1037853turnable
typable1435883typable
unable83819223_unable
usable84012553_usable
useable9911063useable
variable13310063variable
vendable14159693vendable
venerable1438483venerable
veritable1448743veritable
vernacle1345583vernacle
viable111613773_viable
vocable14189673vocable
votable122111373votable
wadable13310233wadable
warble113516603war_ble
waxable1937673waxable
wearables14155003wearables
weldable1436863weldable
wettable13148043wettable
workable1737093workable
writable1338753writable

Search took 8 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.1701051123.5
2DLD Change Limit1340273166.75019855.9
3Display Results3163160.1102872.7
 (SQL Overall)1786913167.03025418.3
 
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.