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

225 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
editable1131042(None) 
evitable1339321evitable
agitable1138582agitable
auditable1245992auditable
bitable11312202_bitable
citable11313462_citable
creditable1546002creditable
datable101714232_datable
disable10516432_disable
eatable91717602e_atable
edible969352edi__ble
educable1337092educable
equitable2046192equitable
excitable2056242excitable
exilable1737202exilable
heritable1439452heritable
imitable1239122imitable
medicable1647502medicable
suitable10310892suitable
veritable1448742veritable
writable1338752writable
abatable1238023abatable
abdicable1685023abdicable
actable11313473_actable
adaptable1444613adaptable
addable11218843ad_dable
admirable1445433admirable
adoptable1444753adoptable
adorable1138773adorable
advisable1544573advisable
amiable11312033ami_able
amicable1438433amicable
bailable1238583bailable
beatable121612243beatable
beddable14166923bed_dable
biddable14165673biddable
biteable1237933_biteable
boatable121610263boatable
boilable1237793boilable
bootable12179223bootable
bribable1137223bribable
cartable121314093cartable
castable121613973castable
citeable1238413_citeable
cogitable1446943cogitable
coinable12311583coinable
creditably1844543creditably
cuttable1247953cuttable
dateable1149443_dateable
debatable1446313debatable
decidable1547223decidable
definable1547773definable
deletable12149503deletable
demisable1448533demisable
deniable11312083deniable
denotable1238373denotable
deputable1487043deputable
derivable1548063derivable
desirable1249393desirable
devisable1546853devisable
dibble114013843_di_bble
dilatable1246853_dilatable
dimmable1536113_dimmable
dippable1536123_dippable
disabled1248713_disabled
disabler1147913_disabler
disables11410903_disables
doable93115243_d_oable
dowable13189453_dowable
drivable1438023drivable
dryable13237433_dryable
dubitable1445093dubitable
dupable12238383_dupable
durable102312723_durable
dutiable1137373_dutiable
dyable12308983_d_yable
dyeable1337303_dyeable
eatables10169793e_atables
edibles1048003edi__bles
edictal1046993edicta_l_
edictally1545473edictally
edile64819493edi___le
educables1443473educables
educible1344433educible
effable15106673e_ffable
ejectable20136573ejectable
electable13149623electable
elidible1164573elidible
eligible11114693eligible
emptiable1544843emptiable
enable83318483e__nable
enactable1338493enactable
endurable1247733endurable
enviable1337853enviable
equable1849253e_quable
equatable2045193equatable
equitably2344423equitably
eradicable1545633eradicable
erasable10511043erasable
erectable131210093erectable
erodable1139203erodable
errable9312183e_rrable
estimable1346043estimable
evadable1436363evadable
evocable1537103evocable
exactable2046433exactable
excisable2045053excisable
excitably2364493excitably
exigible18113683exigible
exorable1738933exorable
expiable1946113expiable
eyeable1239063e_yeable
finable122213623_finable
fittable1337093fittable
fixable19218193_fixable
foilable1338063foilable
friable122612563fri_able
gainable1138933gainable
getable101712553_getable
getatable1235953getatable
gettable11178133gettable
giftable1465893giftable
guidable1236203guidable
gustable11138203gustable
habitable1645953habitable
hatable121713963_hatable
heatable131612043heatable
heritably1746813heritably
hidable1399403_hidable
hirable121612313_hirable
hittable1336853hittable
huntable1338093huntable
ignitable1245463ignitable
incitable13310433incitable
indictable1547493indictable
inevitable1557643inevitable
instable10313203instable
irritable1148053irritable
jailable1737143jailable
joinable1737283joinable
judicable2143643judicable
knittable1544243knittable
leviable1337513levi_able
liable81415813_li_able
liftable1376863liftable
likable13219413_likable
limitable1345643limitable
linable92214343_linable
listable10810313listable
livable122010323_livable
mailable1239623mailable
meditate11310623medita_te
meltable12310473meltable
minable112315073_minable
mixable18259173_mixable
mutable11312303_mutable
nestable101613673nestable
nettable101610243nettable
notable92114903_notable
oxidable1865123oxidable
paintable1337243paintable
pettable121710713pettable
pitiable1238293_pitiable
pliable111610323pli_able
pointable1337343pointable
portable12313203portable
potable112115363_potable
predicable1747193predicable
predictable1844993predictable
printable1338203printable
quotable1936493quotable
radiable11611303radi_able
raisable10311643raisable
ratable91717553_ratable
refinable1438623refinable
refutable1477863refutable
relatable11310053relatable
reliable10313073reli_able
relivable1438513relivable
remittable1445743remittable
rentable101716333rentable
reputable1379123reputable
restable101618443restable
retable91820403_retable
revisable1437993revisable
revivable1736863revivable
ridable101412493_ridable
rideable1158653rideable
ruinable1039263ruinable
rustable101511363rustable
sailable10310563sailable
satiable10310733satiable
seisable10311373seisable
seizable1938723seizable
shiftable1744893shiftable
sizable1839893_sizable
skiable1338883ski_able
slidable1137953slidable
sortable10312483sortable
stable83921643__stable
statable10310703statable
suitably1347593suitably
table75429603___table
tastable101511973tastable
temptable1545813temptable
testable101412623testable
tiltable10159013tiltable
tithable1336853_tithable
titrable1038963_titrable
totable92313363_totable
triable92515393tri_able
twistable1444273twistable
undatable1238983undatable
unstable10313763unstable
vegetable1545683vegetable
veritably1746543veritably
viable111613773_vi_able
visitable1445873visitable
vitiable1337503_vitiable
voidable1466853voidable
votable122111373_votable
wastable131410453wastable
wettable13148043wettable
wirable121610963_wirable
writeable1444613writeable

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.436409841.7
2DLD Change Limit1461622257.95318378.2
3Display Results2252250.0932419.4
 (SQL Overall)1786912258.48221067.1
 
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.