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

230 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
pettable12171071(None) 
gettable11178131gettable
nettable101610241nettable
wettable13148041wettable
beatable121612242beatable
cuttable1247952cuttable
eatable91717602_eatable
fittable1337082fittable
getable101712552ge_table
getatable1235952getatable
heatable131612042heatable
hittable1336842hittable
meltable12310472meltable
nestable101613672nestable
peccable1648102peccable
peelable1238552peelable
pentacle1239382pentacle
petrale9312622petra_le
pettle84116052pett__le
pitiable1238292pitiable
portable12313202portable
potable112115362p_otable
rentable101716332rentable
restable101618432restable
retable91820402re_table
spottable1345342spottable
testable101412622testable
abatable1238023abatable
actable11313473_actable
agitable1138583agitable
avertable14117343avertable
bearable121512363bearable
beddable14166923beddable
bendable131510853bendable
bitable11312203_bitable
biteable1237933biteable
boatable121610263boatable
bootable12179223bootable
cartable121314093cartable
castable121613973castable
cheatable1646713cheatable
citable11313463_citable
citeable1238413citeable
creatable1339563creatable
datable101714233_datable
dateable1149443dateable
debatable1446313debatable
deletable12149503deletable
deniable11312083deniable
denotable1238373denotable
deputable1487033deputable
detectable15136593detectable
detestable13136503detestable
detonable1247623detonable
dutiable1137373dutiable
eatables10169793_eatables
editable11310423editable
effable15106673_effable
ejectable20136573ejectable
electable13149623electable
enable83318483_e_nable
equable1849253_equable
erectable131210093erectable
errable9312183_errable
evitable1339323evitable
expectable2345063expectable
eyeable1239063_eyeable
feedable1437673feedable
fellable13179133fellable
fettle93713123fett__le
gelable101710733ge_lable
giftable1465893giftable
gustable11138203gustable
hatable121713963_hatable
hateable1339373hateable
healable131610173healable
hearable131611603hearable
helpable1536603helpable
heritable1439453heritable
hewable15177823he_wable
huntable1338093huntable
imitable1239123imitable
instable10313193instable
keepable1635323keepable
kettle104311613kett__le
knittable1544243knittable
leasable101510133leasable
lendable11169463lendable
leviable1337513leviable
liftable1376863liftable
listable10810303listable
mendable131510583mendable
metastable1444923metastable
mettle83815723mett__le
mutable11312303_mutable
nettle64514583nett__le
notable92114903_notable
openable1247013ope_nable
operable12410323ope_rable
outfable1378813outfable
packable1838633packable
paintable1337243paintable
palatable1346373palatable
palpable1448033palpable
parable111819773p_arable
parsable12311693parsable
partible1238063partible
passable12310623passable
patchable1845633patchable
patentable1444933patentable
pawnable1535983pawnable
payable141711323p_ayable
peaceable1548243peaceable
pebble1238003pe__bble
pectase112410363pecta_se
pectate112214693pecta_te
peltate92013773pelta_te
penetrable1446043penetrable
pentacles1338763pentacles
pentane9415743penta_ne
pentangle1244993pentangle
peptalk1554823pepta_lk
percale11314083perca_le
permeable1556813permeable
permutable1644983permutable
perusable1347453perusable
pesthole1347553pesthole
pestle83215843pest__le
petabyte1542783pe_tabyte
petal76526893pe_ta_l_
petaled103614143pe_ta_led
petalled1138683pe_talled
petals84719813pe_ta_ls
petiole9311303pe_tiole
petrales10312953petra_les
pettedly1443873pettedly
pettily1238173pett_ily
pettled103611503pett__led
pettles93916483pett__les
pitiably1545843pitiably
pittance1246113pittance
pivotable1644563pivotable
placable14169243placable
plantable1337273plantable
playable15137923playable
pleadable1445513pleadable
pliable111610323p_liable
plowable1535913plowable
pointable1337343pointable
pokable15209503p_okable
portables1337873portables
portably1539313portably
posable112212783p_osable
potables12179703p_otables
pottage103310603potta_ge
pottle84416103pott__le
pourable1239133pourable
pregnable1456693pregnable
previable1647533previable
printable1338203printable
probable1439053probable
provable1539093provable
prunable1237843prunable
quotable1936493quotable
ratable91717553_ratable
rateable10311443rateable
readable11313163readable
reapable12311393reapable
rebuttable1443943rebuttable
reefable1339533reefable
reelable10311593reelable
refutable1477863refutable
relatable11310053relatable
reliable10313073reliable
remittable1445733remittable
repeatable1447603repeatable
reputable1379123reputable
resettable1256503resettable
restabled12148943restabled
restables111511423restables
retables101712673re_tables
reusable10811273reusable
rotatable1146653rotatable
rustable101511353rustable
satiable10310733satiable
sealable101512693sealable
seeable91113943se_eable
seisable10311373seisable
seizable1938723seizable
sellable101711823sellable
sendable111612043sendable
servable13310083servable
settle63915663sett__le
settleable1242583settleable
sewable121911173se_wable
sortable10312483sortable
speakable1745373speakable
spectacle1544083spectacle
spendable1446463spendable
stable83921643__stable
statable10310703statable
stewable1337133stewable
suitable10310893suitable
table75429603___table
tastable101511973tastable
tearable101512673tearable
teasable101511173teasable
tellable10169773tellable
temptable1545813temptable
tenable93214493te_nable
tentacle1037693tentacle
tiltable10159013tiltable
tithable1336853tithable
titrable1038963titrable
totable92313363_totable
toteable1048353toteable
treatable1139323treatable
uneatable11311693uneatable
unstable10313763unstable
vegetable1545683vegetable
vendable14159693vendable
veritable1448743veritable
vitiable1337503vitiable
votable122111373_votable
voteable1347213voteable
wastable131410453wastable
wearable131510553wearable
weldable1436863weldable
writable1338753writable
zettabyte235983zettabyte

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.1731032896.0
2DLD Change Limit1461622308.04618165.8
3Display Results2302300.1102090.9
 (SQL Overall)1786912308.32921454.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.