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

163 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
prunable123784(None) 
burnable1237262burnable
pawnable1535982pawnable
perusable1347452perusable
pourable1239132pourable
pregnable1456692pregnable
printable1338202printable
probable1439052probable
provable1539092provable
prunelle1044982prunelle
ruinable1039262_ruinable
rulable9310532_rulable
tunable92511312_tunable
turnable1037852turnable
unable83819222__unable
abusable1236373abusable
amenable1238863amenable
amusable1237143amusable
arable81821003ar__able
arguable1135903arguable
arousable1145573arousable
atonable1038793atonable
bannable1278353bannable
boundable1444843boundable
bribable1137223bribable
burnables1344003burnables
buyable1437493_buyable
causable1239973causable
clubable1436093clubable
coinable12311583coinable
countable1348853countable
crucible1445193crucible
crumble133410403cru_mble
crunchable1942513crunchable
crushable1645263crushable
curable112414513_curable
curbable1447663curbable
damnable1347593damnable
drainable1237583drainable
drapable1377573drapable
drawable1467113drawable
drinkable1644113drinkable
drivable1438023drivable
drumble12337893dru_mble
dryable13237433dr_yable
dupable12238383_dupable
durable102312723_durable
educable1337093educable
enable83318483__enable
equable1849253equ_able
erasable10511043erasable
erodable1139203erodable
errable9312183er_rable
finable122213623_finable
framable1537573framable
frankable1844923frankable
friable122612563fr_iable
fryable15277463fr_yable
furlable1335893furlable
gainable1138933gainable
gradable1238823gradable
grantable1257293grantable
grazable2036223grazable
groupable1443643groupable
growable1435623growable
grumble12349233gru_mble
gruntle8257053grun_tle
huntable1338093_huntable
incunable13108743incunable
joinable1737283joinable
laudable1137893laudable
lienable10188693lienable
linable92214343_linable
loanable1037613loanable
minable112315073_minable
mountable1346303mountable
mutable11312303_mutable
openable1247013openable
ownable1237283_ownable
packable1838633packable
paintable1337243paintable
palpable1448033palpable
parable111819773p_arable
pardonable1544023pardonable
parolable1347113parolable
parsable12311693parsable
passable12310633passable
payable141711323p_ayable
peccable1648123peccable
peelable1238553peelable
perdurable1544753perdurable
permeable1556823permeable
permutable1644983permutable
personable1467073personable
pettable121710713pettable
pinnacle12416963pinnacle
pitiable1238293pitiable
placable14169243placable
plantable1337273plantable
playable15137923playable
pliable111610323p_liable
plowable1535913plowable
plumbable1743323plumbable
pointable1337343pointable
pokable15209503p_okable
portable12313203portable
posable112212783p_osable
potable112115363p_otable
preamble1436383preamble
prename11412643prena_me
presale9416353presa_le
presumable1645203presumable
previable1647533previable
priceable1546823priceable
probables1545433probables
probably1746413probably
procurable1644863procurable
pronate9418873prona_te
provably1846213provably
prune75119633prun___e
prunella1044073prunella
prunelles1145063prunelles
prunello1043433prunello
pungle94413573p_un_gle
purgeable1444413purgeable
pursuable1344693pursuable
ratable91717553_ratable
rentable101716333_rentable
retable91820403_retable
reusable10811273reusable
ridable101412493_ridable
rinsable10310043_rinsable
ropable111611333_ropable
rowable121510303_rowable
rubble104315673_ru_bble
ruble74521253_ru__ble
rumble103718813_ru_mble
rundle73214233_run_dle
runkle103611543_run_kle
rustable101511363_rustable
scrutable1346043scrutable
shunnable1443203shunnable
soundable1245983soundable
stonable1039843stonable
suable83920553_su_able
surfable1338443surfable
tannable1039383tannable
tenable93214493_tenable
tradable1139873tradable
trainable1138943trainable
triable92515393tr_iable
truckable1744513truckable
trundle8307873trun_dle
trustable1147123trustable
tunably12218293_tunably
tuneable1038913_tuneable
turntable1144983turntable
unbale83616403__unbale
untunable1147833untunable
unusable1038953unusable
usable84012553__usable
winnable13156983winnable
writable1338753writable

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.846211218.7
2DLD Change Limit1461621637.65319098.7
3Display Results1631630.0632587.3
 (SQL Overall)1786911638.56220870.2
 
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.