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

253 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
addable1121884(None) 
addible11236061addible
actable11313472actable
addle74318352add__le
adorable1138772adorable
affable15117402affable
amiable11312032amiable
arable81821002a_rable
audible10228242audible
beddable14166922beddable
biddable14165672biddable
codable12311662codable
datable101714232datable
doable93115242_doable
dyable12308982_dyable
fadable13310462fadable
hidable1399402hidable
laudable1137892laudable
radiable11611302radiable
ridable101412492ridable
sandable111612822sandable
wadable13310232wadable
wadeable1437442wadeable
abatable1238023abatable
abdicable1685023abdicable
able66340533___able
abradable1495063abradable
abubble1044523abubble
abusable1236373abusable
adage7414053a_da_ge
adaptable1444613adaptable
addax1435993adda__x
addaxes1634573addaxes
addedly1344293addedly
addled94112523add__led
addles84216603add__les
adduce1076453add_uce
adducible1542213adducible
adherable1545003adherable
admirable1445433admirable
adnate72913483adna_te
adobe84814713a_dob_e
adoptable1444753adoptable
adorably1446443adorably
advance1346043advance
advisable1544573advisable
aedile73716653aed_ile
affably1855183affably
agitable1138583agitable
alible8311973a_lible
alliable1038433alliable
amble95924643a__mble
amenable1238863amenable
amendable1446053amendable
amiably1438303amiably
amicable1438433amicable
amusable1237143amusable
andante8311273andante
arables91814973a_rables
arguable1135903arguable
atonable1038793atonable
audibled12224093audibled
audibles11215533audibles
audibly13216043audibly
audile73315303aud_ile
auditable1245993auditable
avoidable15124743avoidable
avowable1635453avowable
awardable1543953awardable
bailable1238583bailable
bankable1677913bankable
bannable1278353bannable
barrable1249243barrable
bedabble1243703bedabble
bendable131510853bendable
biddably17173543biddably
bindable13169623bindable
bitable11312203bitable
boardable1444893boardable
bondable13169273bondable
buyable1437493buyable
cable95329913__cable
callable12310753callable
capable13313363capable
cartable121314093cartable
cascable141510623cascable
cashable15159793cashable
castable121613973castable
causable1239973causable
citable11313463citable
curable112414513curable
dabble114515193_dabble
daddle94214283dad_dle
dale55643983__da_le
damnable1347593damnable
dateable1149443dateable
dibble114013843_dibble
disable10516433disable
double94013993_double
dowable13189453dowable
drabble12238883_drabble
drably123511613_drably
dryable13237433dryable
dupable12238383dupable
durable102312723durable
dyeable1337303dyeable
eatable91717603eatable
edible969353_edible
editable11310423editable
educable1337093educable
effable15106673effable
enable83318483_enable
equable1849253equable
erodable1139203erodable
errable9312183errable
evadable1436363evadable
eyeable1239063eyeable
fable105824753__fable
faceable15108493faceable
farmable1538203farmable
feedable1437673feedable
finable122213623finable
findable14179023findable
fixable19218193fixable
flyable15307123flyable
foldable1437133foldable
fordable1439593fordable
friable122612563friable
fryable15277463fryable
gable85325523__gable
gainable1138933gainable
gelable101710733gelable
getable101712553getable
gradable1238823gradable
guidable1236203guidable
hackable1937473hackable
hangable1438213hangable
hatable121713963hatable
hateable1339373hateable
hewable15177823hewable
hirable121612313hirable
holdable1437073holdable
jailable1737143jailable
jammable2144513jammable
lapsable12117383lapsable
laudably1445123laudably
lendable11169463lendable
liable81415813_liable
likable13219413likable
linable92214343linable
livable122010323livable
losable91910953losable
lovable12179553lovable
mailable1239623mailable
makable15510203makable
makeable1637253makeable
mandible1337543mandible
mappable1635923mappable
maskable1638003maskable
mendable131510583mendable
minable112315073minable
mixable18259173mixable
moldable1337103moldable
movable14189433movable
mutable11312303mutable
namable11312343namable
nameable1238863nameable
notable92114903notable
oddball1143773oddball
ownable1237283ownable
oxidable1865123oxidable
packable1838633packable
paddle104615143padd__le
palpable1448033palpable
parable111819773parable
parsable12311693parsable
passable12310633passable
pawnable1535983pawnable
payable141711323payable
pliable111610323pliable
pokable15209503pokable
posable112212783posable
potable112115363potable
raddle84816173radd__le
radiale83813523radia_le
raisable10311643raisable
ratable91717553ratable
rateable10311443rateable
readable11313163readable
retable91820403retable
rideable1158653rideable
ropable111611333ropable
rowable121510303rowable
rulable9310533rulable
sable74732163__sable
saddle83915493sadd__le
sailable10310563sailable
salable91415463salable
saleable10312023saleable
salvable1338403salvable
satiable10310733satiable
savable121711863savable
saveable1339003saveable
sayable121411613sayable
seeable91113943seeable
sendable111612043sendable
sewable121911173sewable
shedable1437423shedable
sheddable1643693sheddable
sizable1839893sizable
skiable1338883skiable
slidable1137953slidable
sowable121610753sowable
stable83921643_stable
suable83920553_suable
table75429603__table
takable13310193takable
takeable1437463takeable
talkable1437193talkable
tamable11312853tamable
tameable1238603tameable
tannable1039383tannable
tapeable1238823tapeable
tappable1436343tappable
tastable101511973tastable
taxable1639073taxable
tenable93214493tenable
totable92313363totable
towable121910113towable
tradable1139873tradable
tradeable1247413tradeable
triable92515393triable
tunable92511313tunable
typable1435883typable
unable83819223_unable
undoable1139053undoable
usable84012553_usable
useable9911063useable
valuable1336863valuable
variable13310063variable
vendable14159693vendable
viable111613773_viable
vocable14189673vocable
voidable1466853voidable
votable122111373votable
waddle114715303wadd__le
walkable1736063walkable
washable16138043washable
wastable131410453wastable
waxable1937673waxable
weldable1436863weldable
windable14159153windable
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.403443402.0
2DLD Change Limit1340272535.84622926.3
3Display Results2532530.0932720.4
 (SQL Overall)1786912536.34228175.8
 
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.